How to add OS Edition in webreports-Explore Data

Joby · October 30, 2018, 5:28am

RiyazBasha · October 30, 2018, 7:00am

Are you looking for OS Version?
If so,go to the Edit columns and then select the OS Version it will show you the version of the OS installed on the endpoints.

Hoping it helps you

Joby · October 30, 2018, 8:41am

No, Looking for an Windows edition- Ex:- Standard, Enterpirse, etc

AlexaVonTess · October 30, 2018, 9:40am

if (exists wmi AND (not (name of operating system = "WinME" ))) then (string value of selects "caption from win32_operatingsystem" of wmi & " " & csd version of operating system) else ( "Windows " & (following text of first "Win" of (name of operating system as string)) & (if (name of operating system = "WinNT" ) then ((if (exists key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ProductOptions" whose (exists value "ProductType" of it AND (value "ProductType" of it as string as lowercase = "servernt" OR value "ProductType" of it as string as lowercase = "lanmannt" )) of registry) then (if (exists key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ProductOptions" whose (exists value "ProductSuite" of it AND value "ProductSuite" of it as string as lowercase contains "terminal" ) of registry) then " Terminal Server" else " Server" ) else " Workstation" ) & " " & csd version of operating system) else (if (name of operating system = "Win98" ) then (if (csd version of operating system as string contains "A" ) then " Second Edition" else "" ) else (if (name of operating system = "Win95" ) then (if (csd version of operating system as string contains "C" OR csd version of operating system as string contains "B" ) then " OSR2" else "" ) else " " & csd version of operating system ))))

s.borrelli · October 30, 2018, 1:15pm

AlexaVonTess:

if (exists wmi AND (not (name of operating system = “WinME” ))) then (string value of selects “caption from win32_operatingsystem” of wmi & " " & csd version of operating system) else ( “Windows " & (following text of first “Win” of (name of operating system as string)) & (if (name of operating system = “WinNT” ) then ((if (exists key “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ProductOptions” whose (exists value “ProductType” of it AND (value “ProductType” of it as string as lowercase = “servernt” OR value “ProductType” of it as string as lowercase = “lanmannt” )) of registry) then (if (exists key “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ProductOptions” whose (exists value “ProductSuite” of it AND value “ProductSuite” of it as string as lowercase contains “terminal” ) of registry) then " Terminal Server” else " Server" ) else " Workstation" ) & " " & csd version of operating system) else (if (name of operating system = “Win98” ) then (if (csd version of operating system as string contains “A” ) then " Second Edition" else “” ) else (if (name of operating system = “Win95” ) then (if (csd version of operating system as string contains “C” OR csd version of operating system as string contains “B” ) then " OSR2" else “” ) else " " & csd version of operating system ))))

how do you use this?

AlexaVonTess · October 30, 2018, 1:29pm

Your BigFix admin will know. They’ll add it as a Managed Property or in an Analysis.

s.borrelli · October 30, 2018, 3:13pm

great. it works fine.

Joby · October 31, 2018, 4:12am

I am not able to do it, can i have the steps please

s.borrelli · October 31, 2018, 8:11am

Tools --> create new analysys
in properties tab --> add property and paste the code from alexa (pay attention at the “” quote)
In relevance select yout condition and add also “OS” contains “win”