Discovery and Inventory Group

 View Only
Expand all | Collapse all

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

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

    Posted Jun 28, 2013 10:32 AM


  • 2.  RE: I need to create a report of computers with windows 8 are not yet managed

    Posted Jun 28, 2013 11:52 AM

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

    Thanks
    Cheryl



  • 3.  RE: I need to create a report of computers with windows 8 are not yet managed

    Posted Jun 28, 2013 12:06 PM

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



  • 4.  RE: I need to create a report of computers with windows 8 are not yet managed
    Best Answer

    Posted Jun 28, 2013 01:01 PM

    Try this: 

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



  • 5.  RE: I need to create a report of computers with windows 8 are not yet managed
    Best Answer

    Posted Jun 28, 2013 01:02 PM

    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