Combining multiple queries in one collection – SCCM

I was hired for one secondment, and I moved to  much bigger  environment. And one of task was to deploy Office 2016. Ill write another post of deploying Office 2016 with scripts to uninstall previous version of Office.

After some digging, I figured that environment has mixed versions of Office in place.  After creating initial Collections for Office 2010 and 2013, also I created the 32bit versions of collection.
Below you can find examples for query of Office 2016

The best way to detect applications is to use GUID of programs you wish to detect.

Also you can use this information  using powershell command to get some third party application GUID and implement detection method.

The command is:

wmic product where "Name like '%Office%'" get name,version,identifyingnumber

 

This is GUID for Office versions.

Office 2013 (32-bit) 

Display Name                                  Product ID
------------                                  ----------
Microsoft Office Professional Plus 2013       {90150000-0011-0000-0000-0000000FF1CE}
Microsoft Visio Professional 2013             {90150000-0051-0000-0000-0000000FF1CE}
Microsoft Project Professional 2013           {90150000-003B-0000-0000-0000000FF1CE}

Office 2013 (64-bit) 

Display Name                                  Product ID
------------                                  ----------
Microsoft Office Professional Plus 2013       {90150000-0011-0000-1000-0000000FF1CE}
Microsoft Visio Professional 2013             {90150000-0051-0000-1000-0000000FF1CE}
Microsoft Project Professional 2013           {90150000-003B-0000-1000-0000000FF1CE}

Office 2016 (64-bit) 

Display Name                                  Product ID
------------                                  ----------
Microsoft Office Professional Plus 2016       {90160000-0011-0000-1000-0000000FF1CE}
Microsoft Visio Professional 2016             {90160000-0051-0000-1000-0000000FF1CE}
Microsoft Project Professional 2016           {90160000-003B-0000-1000-0000000FF1CE}

 

This is example of collection query based on version of Office installed. Its pretty self explanatory.

 

Office 2013 – 32 bit Detection rule
office 2016
Office 2016 – 64 bit Detection  rule

 

 

 

 

 

 

 

 

But I wanted to check if there is computers that have Office 2010 and 2016, installed, or any other combination.

Continue reading “Combining multiple queries in one collection – SCCM”

Advertisements

SCCM Console – unable to connect.

After installing fresh version of Windows 1803 on my laptop i have started to install all my tools on it.

After installing SCCM console, from location noted below, I couldn’t connect.
I verified that I am using same version and that i have right amount of rights to SCCM server.

<Configuration Manager site server installation path>\Tools\ConsoleSetup\

 

 

After examining log console file from location :

C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\AdminUILog\SmsAdminUI.txt

The log file showed that my performance counter is not running

 [1, The performance counter '# images' was not found
[1, The performance counter '# images' was not found
[6, The performance counter '# result objects in memory' was not found
[6, The performance counter '# exceptions' was not found
[6, The performance counter '# exceptions' was not found
[6, The performance counter '# result objects in memory' was not found
[6, The performance counter '# exceptions' was not found
[6, The performance counter '# images' was not found
[1, The performance counter '# images' was not found 

The way to solve this is to run elevated command prompt and run LODCTR /R and reinstalling the console solved the problem.

 

Hope it will help someone.

Deploying BGInfo using SCCM

So, its been a while, but lets start.

Today, I was googling how to deploy BGinfo Using SCCM. Everybody suggested on community to use GPO for this task.

I didn’t like that method because I like to have more info about deployment. Also we have AGPM Group policy in place and I hate all the authoring that comes with AGPM.

So the way I did it is that I created the config file, copy it on local disk and run script that kicks of the BGinfo.

Continue reading “Deploying BGInfo using SCCM”

SCCM and WSUS (Cannot open Database “SUSDB”)

 

Today, I came a cross with alert on my SCCM console regarding SUP synchronization.

SCCM

 

After looking into WMC.log. The error log indicates that WSUS is unable to open and connect to DB. (internal DB)

 Cannot open database “SUSDB” requested by the login. The login failed.~~Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.~~

Continue reading “SCCM and WSUS (Cannot open Database “SUSDB”)”