License Modules Allocation per client – usage vs allocated

Rave101208

We have deployed many customers  on the single SolarWinds instances. Want to know the license usage against each customer. Is there a way to pull a report or through an sql query.

stuartd

The easiest way I can think to do this would be to ensure you have a unique way of identifying each client. We have a 'single pane of glass' setup that sounds like yours, and we identify each client with a unique prefix. That prefix is in the form of a Custom Property (CP) that we assign to each node. We call that CP 'Client'

From there you can build out an inventory report and include said CP in that report. You can then filter the report in Excel to get just the client you want and see the count quite easily..

A simple node report might look like: (BTW - this does not exclude ICMP only nodes)

SELECT 
    NodeID
    , IPAddress
    , Caption
    ,N.CustomProperties.Client

FROM Orion.Nodes AS N
ORDER BY N.CustomProperties.Client ASC

And a similar one for Interfaces could be:

SELECT 
    InterfaceID
    , Name
    ,NI.Node.CustomProperties.Client

FROM Orion.NPM.Interfaces AS NI
ORDER BY NI.Node.CustomProperties.Client ASC

The beauty of this is that you only need a unique reference on the nodes, but you link to it via the inherent links in the SWQL tables. Anyway, you could put both of the above code blocks into a single custom report and you'd end up with two tabs in an Excel s/s - one for nodes and one for interfaces. Just filter away and bish, bash, bosh.

CAVEAT one word of caution. Depending on the size of your deployment then running either of these could p[potentially slow your system down whilst it runs. In other words - choose the time of day/night you run it wisely.