Is the Ticket # a custom field that is manually updated or have you tied your ticket system to NPM?
The ticket #, summary and assignee are custom fields which require technicians to fill in the data. My organization is migrating to the Remedy on Demand cloud service and we are working with BMC to determine if those fields can be auto-populated.
+1 to that question, and from a larger perspective - more details on that resource! Is that a custom swql resource?
The first step was to create four custom properties (bolded in query) then we created an Advanced SQL report through the Report Writer.
We use the Nodes.Test custom property to remove resources in our Test / Dev environments that we do not want populating the report.
Below is the query used:
Nodes.Ticket_Number AS Ticket#,
Nodes.Ticket_Summary AS Summary,
Nodes.Ticket_Assignee AS Assignee
FROM alertdefinitions INNER Join alertstatus on (alertdefinitions.alertdefid = AlertStatus.AlertDefID) inner join nodes on (alertstatus.activeobject = nodes.nodeid)
AlertDefinitions.ObjectType = 'node'
(ALERTDEFINITIONS.ALERTNAME Like ('%Status !=%') )
Nodes.Status = 2
(Nodes.Test = 'False')
Order by 4 desc
Tony is it possible for you to the export the Down nodes for use in Report writer, I am very interested in that resource.
I can seem to get it the query to run.