We had set up a graphical report that showed the temperature of several probes we had throughout our environment. The report displayed the past 14 days. The user then requested the raw data so they could export it out to Excel. The graphical web based reports don't support the export function so we wrote up a simple SWQL query to get the data. The UDP query below was then included into a report.
In the report we actually only needed the AssignmentName, DateTime, and RawStatus columns but I left a few of the others in the query in case they are useful for you. Place your UDP Poller where shown as YOURPOLLERNAMEGOESHERE
If you need a list of poller names run this query
SELECT DISTINCT UniqueName AS YOURPOLLERNAME, CustomPollerID, Description, OID, MIB, SNMPGetType, NetObjectPrefix, GroupName, PollerType, CustomPollerParserID, Format, Enabled, IncludeHistoricStatistics, Unit, TimeUnitID, TimeUnitQuantity, DefaultDisplayTimeUnitID, LastChange, PollInterval, ColumnNumber, DisplayName, InstanceType, Uri, InstanceSiteId
FROM Orion.NPM.CustomPollers
Universal Device Poller Report
SELECT cp.AssignmentName, TOLOCAL(DateTime) AS LocalDateTime, nd.RawStatus, cp.CustomPollerAssignmentID, cp.CustomPollerID, cp.NodeID, cp.CustomPollerDescription, cp.ID, cp.CustomPollerName
FROM Orion.NPM.CustomPollerAssignment cp
INNER JOIN Orion.NPM.CustomPollerStatistics nd on cp.CustomPollerAssignmentID = nd.CustomPollerAssignmentID
Where DATETIME > ADDDAY(-14, GETDATE()) AND AssignmentName LIKE '%YOURPOLLERNAMEGOESHERE%'
Order BY AssignmentName, DATETIME DESC
