SOLVED SQL query to find Windows 7 Computers

[Ravi Kumar]

Hi, I am looking for a sql query that lists the application installed (with version) from list of all windows 7 computers in my organization.

I will run the query from the management studio, please help me on this.

Thank for your help in advance.

Thank you
Ravi Kumar

 

[Garth]

Have you looked at the built-in reports for this?

 

[Ravi Kumar]

Hello Garth,

I didn't find anything relevant, there are 2 requirement
Installed software only for windows 7 machine.

Please advice

Kind Regards
RAvi Kumar

 

[Garth]

Count of all instances of software registered with Add or Remove Programs

 

[Ravi Kumar]

1. no of windows 7 machines present in the infrastructure.
2. On those machine I want to know a specific installed software.

Kind Regards
Ravi Kumar

 

[Garth]

again, the built in reports will answer those two questions.

 

[Garth]

Now that I'm at the office,

Your first requirement is covered by Count operating system versions
Your second requirement is covered by Computers with specific software registered in Add Remove Programs ; you might need to create a collection for this one.