I have a simple report that will show failed backup jobs.
In looking at the output, it shows everything but the name of the node that failed. So I need to adapt(add) to my report to pull the node name from NPM. Only I have no clue how to do JOINS, let alone much else in SWQL/SQL.
The code so far is simply:
SELECT TOP 1000 UserName, ModuleName, Type, Action, Details, DateTime FROM Cirrus.Audit WHERE Action LIKE '%Download%' AND UserName LIKE '%CLIENT_NAME%' --AND DateTime < ADDDATE('DAY', -7, GETUTCDATE()) AND Type = 'Failed'