Hi everybody,

i would like to get a query that lists the number of Worksations that have Win XP operating Systems And the number of workstations that have Win 7 OS. 

Thank you.

Regards,

Le Balbo

I believe you want SQL query: So here it is

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows XP%')

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows 7%')

• Edited by Ashribad Rout 16 hours 38 minutes ago

Dumb question but what is wrong with the built-in report for this?

Thank you.

 will try this.

Regards,

Hello Mister Jones,

When i use the built-in report,The report returns me a result that is not exactly what i was waiting for .That is why i'm trying something else.

Hello Mister Jones,

When i use the built-in report,The report returns me a result that is not exactly what i was waiting for .That is why i'm trying something else.

What do you mean by this?

The Count of Operating Systems will tell you all of your different OS versions. So... What is it not giving you?

I believe you want SQL query: So here it is

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows XP%')

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows 7%')

• Edited by Ashribad Rout Wednesday, June 17, 2015 3:05 PM

I believe you want SQL query: So here it is

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows XP%')

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows 7%')

• Edited by Ashribad Rout Wednesday, June 17, 2015 3:05 PM

I believe you want SQL query: So here it is

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows XP%')

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows 7%')

• Edited by Ashribad Rout Wednesday, June 17, 2015 3:05 PM

I believe you want SQL query: So here it is

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows XP%')

Select Name0 from v_r_system where ResourceID in (Select ResourceID from V_GS_Operating_system where Caption0 like '%Windows 7%')

• Edited by Ashribad Rout Wednesday, June 17, 2015 3:05 PM