Follow by Email

Tuesday, 9 December 2014

How to Query for Internet Explorer 9 , Internet Exploer 10, Internet Explorer 11 using SCCM2012

 

Enable Software Intelligence first

1 Enable user audit policy in Domain Controller
a. Log in to AD as a domain administrator
b. Click on Start> Administrative Tools>Local Security Policy>
c. Expand Local Policies > Audit Policy > Audit account logon events>click on Success
d. Log off AD

2 Installing and enabling Asset Intelligence
a. Open Configuration Manager on your Primary Site Server
1. Click Administration > Site Configuration>Servers and Site System Roles
2. Right click on your primary site name > Click on Add Site System Roles >Click on Next>Next>Select Asset Intelligence Synchronization point>Next>Next>Next>Close

3 Ensure Hardware Inventory is turned on
a. Go to Administration > Overview Client Settings
b. Right click on default properties, select Hardware Inventory and ensure it is turned on.
c. Click on OK to exit.

4 Telling Asset Intelligence what information to gather
a. Click on Asset and Compliance > Right click on Asset Intelligence > Select Inventory Classes
b. Click on all Asset Intelligence reporting classes and click on OK

5 Checking Asset Intelligence status
a. Click on Asset and Compliance > Asset Intelligence >
Ensure that the following settings are show
1. Asset Intelligence Component : Enabled
2. Asset Intelligence Synchronization point status: Sync Point Deployed
3. Synchronization Schedule: Occurs every 7 days effective

6 Updating the Asset Intelligence Catalog
a. Right click on Asset Intelligence on the Right menu, select Synchronize> Synchronize Asset Intelligence Catalog

Setting Hardware Inventory to get Software Shortcuts

1. In System Center 2012 Configuration Manager, click Administration > Overviewe > Client Settings > Default Client Settings
2. Under Default Settings, click on Hardware Inventory > on the right hand , click on Set Classes…
3. Scroll down the list and select Software ShortCut – Asset Intelligence (SMS_Software ShortCut), check everything in the box, ensure that File Version is checked as well, this is important.
4. Click on OK.
If you have the right hand third party tools installed, right click on the collections you would like to gather information from , select SCCM Client Actions on Collection > Select Hardware Inventory Cycle. A Window will popup saying Open File – Security Warning , click on Run and let it do its Job

Creating a manual Query

1. Go to Monitoring > Under OverView > Right click on Query > Select new Query
2. Name : Computers with Internet Explorer 9
3. Click on Edit Query Statement > Click on Show Query Language
4. Copy and Paste this in

Internet Explorer 9

select distinct SMS_R_System.NetbiosName, SMS_G_System_SOFTWARE_SHORTCUT.FileVersion from 
SMS_R_System inner join SMS_G_System_SOFTWARE_SHORTCUT on SMS_G_System_SOFTWARE_SHORTCUT.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SOFTWARE_SHORTCUT.FileVersion like “%9.00%”

Internet Explorer 10

select distinct SMS_R_System.NetbiosName, SMS_G_System_SOFTWARE_SHORTCUT.FileVersion from 
SMS_R_System inner join SMS_G_System_SOFTWARE_SHORTCUT on SMS_G_System_SOFTWARE_SHORTCUT.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SOFTWARE_SHORTCUT.FileVersion like “%10.00%”

Internet Explorer 11

select distinct SMS_R_System.NetbiosName, SMS_G_System_SOFTWARE_SHORTCUT.FileVersion from 
SMS_R_System inner join SMS_G_System_SOFTWARE_SHORTCUT on SMS_G_System_SOFTWARE_SHORTCUT.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SOFTWARE_SHORTCUT.FileVersion like “%10.00%”

And click on OK

5. Select the Collection you would like to collect the software information from and click on Next > Next > Close.
6. Double click on Computers with Internet Explorer 9 , you should be able to see the Computers with the Internet Explorer 9 version. Note that it will take some time for the computers to populate the database. 

If you want the Entire IE inventory in your IE enviroment, you can use the query below

select distinct SMS_R_System.NetbiosName, SMS_G_System_SOFTWARE_SHORTCUT.FileVersion from  SMS_R_System inner join SMS_G_System_SOFTWARE_SHORTCUT on SMS_G_System_SOFTWARE_SHORTCUT.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SOFTWARE_SHORTCUT.Description like “%Internet Explorer%”

No comments:

Post a Comment