Hi,
Is SQWL able to return me the number of rows of the products not in the top few entries i.e.
select top 3 vendors ...
but the result I want is
Vendor A-5000
Vendor B- 3000
Vendor C- 1000
others - 2000
rawwinton
I'm guessing you are looking for node count by vendor. If that's the case, a query like this will work:
SELECT Vendor, COUNT(1) AS Quantity
FROM Orion.Nodes
GROUP BY Vendor
Pro tip: these kinds of questions will be answered more quickly if posted in the Orion SDK forum.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.