Querying Solarwinds for Device Added Dates

We had the need to create a report that showed us which Windows devices were added into Solarwinds within the last 7 days. With a little poking around and chatting to someone that knows SQL this is what we came up with:

select n.caption as ‘Node Name’ , Min(datetime) as ‘Date Added’, n.vendor
from responsetime r join nodes n on n.nodeid = r.nodeid
where n.vendor = ‘windows’
Group by n.caption,n.vendor
Having Min(datetime) >= getdate() – 7

Things you can change:
Vendor – this can be changed to match any vendor name you have in your node list and will return those nodes
Getdate – The sum after + on the last line can be changed to get the results back which you require

Hope this helps.

(Source for the main part of the SQL: http://thwack.solarwinds.com/thread/39350)