There is a chart report Last Windows Update Chart QueryAnd the SQL query is:Select Top 1000000 Case When LastPatchDate.lastPatchDate >= DateAdd(day, -7, GetDate()) Then '1. less than a week' When LastPatchDate.lastPatchDate < DateAdd(day, ...
I am making a custom report that works but entries are duplicated multiple times. I have 78 printers and the report displays the printers IP location, Manufacturer, Model, SerialNumber, AssetName, Location (Custom Field 01), and the IPAddress.I have...
I have an uptime report that I want to run on the regular, but the current user field is populated by the last logged on user, rather than the "AD manager" field in AD. I need to be able to pull the AD manager in order to get a clean enough report t...
I have a report unauthorized local admins on pc's. I'm looking to also filter out ((User X on PC Y) and (user W on PC Q)) from the report. I can't seem to make it work though.Current report:Select Top 1000000 tblAssets.AssetName, tblUsersInGroup.A...
I need to create a report of all computers that do not have the "Bitdefender Endpoint ..." antivirus installed. Windows defender needs to be ignored from the report.
Hi.I am fairly terrible at SQL, I am trying to relearn it after years away from it. So hopefully someone could help me, I would be very grateful.What I am trying to do is search a specific group of assets by assetname and return an entry for each ass...
Hi all,I am having trouble putting together a report that does the following:Find all assets that have hostname contain ABC OR 123Last seen within last 30 days.
