Example report for showing nodes that have priority Custom Properties not filled in. Empty values means that anywhere you are using that custom property will not be as effective because those nodes won't apply. For example, in the report we are using a CP titled "Decommissioned_Date" which we may be using in an alert. That…
We have two reports that work just fine. They essentially do the same thing, only one reports on running configs and the other on startup configs, and specifically shows the last time that type of config was run. In an attempt to rationalise these reports into one, I just removed the part from my report that restricts it…
We have an issue where a schedule has been deleted along with its reports, however the schedule still runs and is being deleted. I have scoured the database for these reports and schedules, and found no trace of them, however the emails still send. The deletion of the reports stops them being sent, however the emails are…
Hello! I'm attempting to create a report showing triggered alert time, object, node, acnowledgement, and acknowledgement note. The problem I'm running into is that the AcknowledgedBy and AcknowledgedTime fields reside in the AlertStatusView table, where everything else is in the AlertHistoryView table. So I attempted to…
I have a fairly simple query I've created that I now want to use in an air-gapped environment and has no access to SSMS or the SDK. As a consequence I am really struggling to convert it to a format that the Database Manager understands. The query is: SELECT nd.Client, ncp.NodeID, ncp.Name, ncp.Type, ncp.TypeName,…
I'm curious to hear opinions on how accurate people are finding the forecasts. Kevin
Running a report in SQL for response times. I'm curious of the timeframes of Min, Max, Avg response times. For instance, I ran a query and saw 2,198ms max response time with average at 280. How long of polling was that to receive those high numbers? It has since gone down to expected response times.
Building off this report by including extended account permissions that are found in other tables. [View:/cfs-file/__key/communityserver-discussions-components-files/46/Account_2B00_Report_2B00_and_2B00_Extended_2B00_Permissions-_2800_enabled-accounts_2900_.xml:320:240]
So, as per my title really.. I can't find where/how to query the date for when a node last had a successful backup. My current query looks like this: SELECT n.NodeID, n.IPAddress, nc.ClientPrefix, n.Caption, n.MachineType, n.Vendor, n.NCMLicenseStatus.LicensedByNCM, nc.LoginStatus, nc.LastInventory, nc.Node_In_BAU,…
Attached is a report inspired by the thread in the NPM discussions about how to tell who and when a device (node) was added to Orion for monitoring. There are a few nuances to devices being added or deleted, but this will cover most. Note: This requires that the audit log is enabled and the history of this report only goes…
It looks like you're new here. Sign in or register to get started.