Video Screencast Help

I need to create a report of computers with windows 8 are not yet managed

Created: 28 Jun 2013 • Updated: 29 Aug 2013 | 4 comments
This issue has been solved. See solution.
Operating Systems:

Comments 4 CommentsJump to latest comment

ohzone - CherylPeterson's picture

Can you provide more details so other community members can help?


Endpoint Management,
Endpoint Virtualization
Managing Mobility
Community Manager
Need Altiris help? IRC chat #Altiris

LaHuerta's picture

sorry, i have a mistake. what I really need is a filter for windows 8 computers that are not managed

JoeVan's picture

Try this: 

SELECT Guid from vComputer WHERE [OS Name] like 'Windows 8%' and [isManaged] = '0'

Joe VanHollebeke
Systems Engineer

MThrift's picture

The SQL for this is actually quite easy.

An example would be:

SELECT Guid FROM vComputer

WHERE [OS Name] LIKE 'Windows 8%'

AND IsManaged = 0