I came across an interesting request while working with a client today to report on HP warranty information in Orion, and wanted to share how this was accomplished with the community because I think it's pretty neat.
In the past, I've pulled data out of the NCM DB and used the report writer for those reports, so this wasn't really much more difficult than that. First, the two database servers have to by linked, and then the Orion DB account has to have DBO access to the HP management DB. Once this has been accomplished, you can build your report in the Report Writer using a Custom SQL Report:
SELECT
w.DeviceName,
n.Caption,
DateAdd(s,w.StartDate/1000, '1970-01-01') AS UTC_StartDate,
DateAdd(s,w.EndDate/1000, '1970-01-01') AS UTC_EndDate,
w.ExpirationStatus
FROM
[YOURINSIGHTSERVER].[YOURINSIGHTDATABASE].[dbo].[r_warrantycontract] w
JOIN Nodes n on w.DeviceName=n.Caption
/* WHERE NodeID='${NodeID}' */
Notice how the last line has been commented out. Once the report has been formatted to you liking, remove the comment marks (/* & */) and save (RW won't let you run the query with the line in play). Now, from the Node Details view, add the Report from Report Writer, then select your new report. Each node will now show only the warranty data related to it.
