Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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