Hello,
I am looking to write a Custom Report that will give me the "up-time" of all my Remote Cisco switches that I have in my branch offices spreaded throughout the country. Could anyone guide me through the steps to create this report?
This one will output DD:HH:MM:SS.Create an advanced SQL report and drop the below code in the SQL tab.
SELECT Nodes.NodeID, Nodes.Caption AS 'Node Name', Nodes.MachineType AS 'Machine Type', Nodes.LastBoot AS 'Last Boot', ( CONVERT(varchar(6), FLOOR(systemuptime / 86400)) + ':' + RIGHT('0' + CONVERT(varchar(6), (cast(systemuptime as int) % 86400) / 3600), 2) + ':' + RIGHT('0' + CONVERT(varchar(2), (cast(systemuptime as int) % 3600) / 60), 2) + ':' + RIGHT('0' + CONVERT(varchar(2), cast(systemuptime as int) % 60), 2) ) as 'DD:HH:MM:SS'FROM NodesORDER BY 4 desc
