This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

How to Create Assent inventory reports using dynamic query ?

Hi Team,

I a creating all nodes assent inventory report from solarwinds. How to create report by using dynamic query or SQL query.

Please help to me.

Node Name

IP address

location

vendor

machine type

serial number

Above all columns. any one guide to me.

Thanks and Regards,

Kishore.

  • This has way more columns than you asked for as I wrote this query a few weeks ago.

    It's currently showing Dell servers as I have specified Where ONN.HardwareHealthInfos.Manufacturer LIKE '%DELL%'

    You can either change this, or remove the Where line entirely to show everything.

    SELECT

    ONN.Caption As NODE,

    '/Orion/images/StatusIcons/small-' + ToString(ONN.StatusIcon) AS [_IconFor_NODE],   

    '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(ONN.NodeID) AS [_LinkFor_NODE], 

    ONN.IPAddress,

    ONN.MachineType,

    ONN.NodeWarrantyAlert.ExpirationDate,

    ONN.NodeWarrantyAlert.ExpirationDays,

    ONN.NodeWarrantyAlert.WarrantyStatus,

    ONN.NodeWarrantyAlert.OSVersion,

    ONN.NodeWarrantyAlert.OSServicePack,

    ONN.NodeWarrantyAlert.Contact,

    ONN.Location,

    ONN.HardwareHealthInfos.ServiceTag,

    ONN.HardwareHealthInfos.Manufacturer,

    ONN.HardwareHealthInfos.Model,

    ToString(Round(ONN.TotalMemory/1024/1024/1024,1))+' GB' as RAM,

    ONN.AssetInventory.ServerInformation.ProcessorCount,

    ONN.AssetInventory.ServerInformation.MemorySlotsCount,

    ONN.Status,

    ONN.StatusIcon,

    ONN.StatusLED,

    ONN.ChildStatus,

    ONN.NodeName,

    ONN.VirtualMachine.Host.HostName AS VMHost,

    CASE

    WHEN ONN.VirtualMachine.Host.HostName IS NULL THEN 'Physical'

    ELSE 'Virtual'

    END AS HardwareType,

    ONN.DetailsUrl,

    ONN.VendorIcon

    FROM Orion.Nodes ONN

    Where ONN.HardwareHealthInfos.Manufacturer LIKE '%DELL%'

  • Hi i also need device type can you help?