Symantec Management Platform (Notification Server)

 View Only
  • 1.  How to Inventory a Specific Registry Entry Using Custom Inventory

    Posted Sep 10, 2016 11:21 AM

    Was just wondering is someone was able to get this to work?https://support.symantec.com/en_US/article.HOWTO124425.html

    select vc.[guid], vc.name, vc.[ip address], vc.[os name], ic.Value from 
     Inv_Agents-NS ic --Your custom data class table here

    join vComputer vc on vc.[guid] = ic._ResourceGuid

     

    I am getting stuck on the very last step:

    When i try to save a query i am getting an error:

    This DataSource is not in a runnable state.

    Running this in SQL error:

    Msg 102, Level 15, State 1, Line 2
    Incorrect syntax near '-'.

    I understand the problem is with the name. When i try to use "Inv_Agents-NS" then i am getting no data at all

    Thanks for the help



  • 2.  RE: How to Inventory a Specific Registry Entry Using Custom Inventory

    Posted Sep 13, 2016 09:30 AM

    Try:

    select vc.[guid], vc.name, vc.[ip address], vc.[os name], ic.Value from 
     [Inv_Agents-NS] ic --Your custom data class table here
    join vComputer vc on vc.[guid] = ic._ResourceGuid

    I recommend never using non Alphanumeric characters whenever possible.