Serials & Version SWQL Search Resource

Version 6

    Hi Community,

     

    A nifty little resource to help you locate Serial numbers & Versions. Previously I using this as a report but i like the idea to be able to search for serial numbers and other asset information with the search function rather then selecting reports doing some Ctrl + F to find serials etc..

     

    This resource is done using SWQL and the 'Custom Query' resource simply paste the following snippets in and enable the search check box and paste the second snippet there..and enjoy

     

    Query:

     

    Select  
    o.Caption AS [NODE],
    o.detailsurl as [_linkfor_NODE],
    HardwareRevision, FirmwareRevision, SoftwareRevision, Serial 
    FROM Cirrus.Nodes n
    INNER JOIN Cirrus.EntityPhysical s ON n.nodeid = s.nodeid
    INNER JOIN Orion.Nodes o ON o.nodeid = n.corenodeid
    
    
    WHERE EntityClass IN ('2','3') 
    

     

    Search Query:

     

    Select  
    o.Caption AS [NODE],
    o.detailsurl as [_linkfor_NODE],
    HardwareRevision, FirmwareRevision, SoftwareRevision, Serial 
    FROM Cirrus.Nodes n
    INNER JOIN Cirrus.EntityPhysical s ON n.nodeid = s.nodeid
    INNER JOIN Orion.Nodes o ON o.nodeid = n.corenodeid
    
    
    WHERE EntityClass IN ('2','3') 
    AND (  
        o.Caption LIKE '%${SEARCH_STRING}%'OR
        s.HardwareRevision LIKE '%${SEARCH_STRING}%' OR   
        s.FirmwareRevision LIKE '%${SEARCH_STRING}%' OR  
        s.SoftwareRevision LIKE '%${SEARCH_STRING}%' OR
        s.Serial LIKE'%${SEARCH_STRING}%' 
        )  
    

     

    the purpose of putting this in ncm is because this resource utilities the network inventory job

    cheers,

     

    Dan