patriot ✭✭✭✭✭

Anyone?

OK, so here's another report that I got from the Content Exchange. I apologize that I do not remember who the author is. Anyway, where do I add the Nodes.CustomProperties.CustomerName line, and also, can the LEFT INNER JOIN also be eliminated using navigation properties? select n.caption as [Device] -- shows the current…

Not sure I follow, but really just trying to get a report I need - and move toward the time when I don't need so much help with this sort of thing.

Thanks to all who contributed. The KMSigma blog about Navigation Properties really helped. Now, on to the next aspect of SWQL queries - date/time formatting. One step at a time.

I'm still not interpreting things correctly, because I typed this and it does not work: Select IP_Address, Caption, NodeID, Owner FROM Orion.NodesCustomProperties C INNER JOIN Orion.Nodes NodeID on C.NodeID = NodeID.NodeID

I'm not following your reply. Please show me an actual complete query that references a node custom property called, for instance "Owner".

Another question please. I am trying to limit the report to a particular value of the CustomerName, but when I add a line after the WHERE statement, I get an error. Can't tell what I am doing wrong. How would I do that?

Yeah, that's why I asked. Ideally, I would be able to adjust the time frame to pretty much any value. Where is the second place in the query? Line 2?

That worked. One more question. What is the time period for the report? The Where statement seems to indicate it is for the last 3 months. Is that right?

Getting errors on the Edit Resource page. As you can see in the screenshot, there is a specific error message for the CustomerAverage field, but I can't tell what the complaint is about the other four fields. Ideas?

You are correct sir. My apologies. Brain fart.

SELECT TOP 10000 CONVERT(DATETIME, LTRIM(MONTH(DATETIME)) + '/01/' + LTRIM(YEAR(DATETIME)), 101) AS SummaryMonth , Nodes.NodeID AS NodeID , Nodes.CustomerName AS CustomerName , Nodes.Caption AS NodeName , Nodes.IP_Address AS IP_Address , AVG(ResponseTime.Availability) AS AVERAGE_of_Availability , ( SELECT…

Anyone?

However, what does that have to do with MSMQ? The SCP exam prep asks about the "difference between MSMQ and SQLite". That seems like a nonsense question. Any help here? I cannot Google any information comparing MSMQ and SQLite.

The release notes for 2020.2.6 have an entry that says, "Collector and JobEngine are now using SQLite instead of MS SQL CE for internal cache (SDF files)."

The release notes for 2020.2.6 have an entry that says, "Collector and JobEngine are now using SQLite instead of MS SQL CE for internal cache (SDF files)."

Still no one willing/able to assist?

Still no one willing/able to assist?

Anyone?

Anyone?

Thank you jvb. Anyone else have a thought on this? Is there a way to record a mouse click on the OKTA login pop-up as part of a WPM transaction?

Thanks for the quick reply KMSigma. By the way, do you know anything about the values in the Power Control Unit Status widget being inaccurate? Specifically, the Replace Indicator not matching what the device GUI is reporting? Could it be an OID mismatch?

No, but as it happens, we are about to perform some other maintenance processes and upgrade to 2020.2.6, which will of course require the Config Wizard to be run. Should I still reboot all polling engines after all that?

Oooops. Now that I look at the "unmanage" query, I see that it too does not populate the AccountID column even though it looks to me like the Join statement is there: Select N.Caption, N.UnManageFrom, N.UnManageUntil, LastUnmanageEvent.TimeLoggedUtc, AE.AccountID from Orion.Nodes N LEFT OUTER JOIN ( SELECT NetObjectID,…

So, I assume that I could use these SWQL queries in a report as well as in the "custom query" resource on a view, correct?

That fixed it. Thanks much friend.

Result:

I get the following:

Now we seem to be getting somewhere. However, I found that the most recent iteration shows no nodes that are in the DB, but is missing some nodes that should be on the report. I found that if I delete the last two lines in the Where clause, the list of IPs in the report matches the list of FOUND nodes on the Scheduled…

The first query gives a result of 980. The second one a result of 0. Hmmm.