Newbi here - need to run a report of all machines on our network running IE7?
HI all - I am brand new to KACE and am looking to run a report that lists all machines on my appliance that are running IE7. I not even sure where to begin. I'm not an SQL type person, so I went through the wizard, but kinda lost? Anyone have some basic report writing tips they could share?
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
aragorn.2003
9 years ago
We´ve created an Custom Field with Rule
RegistryValueReturn(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer, Version, TEXT)
or (svcversion is available since IE 9.x)
RegistryValueReturn(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer, svcVersion, TEXT)
and a wizard generated report to this custom field.
Posted by:
rock_star
9 years ago
http://www.itninja.com/blog/view/sql-query-custom-report-to-find-internet-explorer-version-installed-on-windows-machine
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, OS_NAME, MACHINE.IP, LAST_SYNC, IE_VERSION FROM MACHINE Where IE_VERSION LIKE '7%'
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, OS_NAME, MACHINE.IP, LAST_SYNC, IE_VERSION FROM MACHINE Where IE_VERSION LIKE '7%'
