Hello, is there a report where I can see the date that a machine updated its Windows version? For example, when it was updated from Windows 10 to Windows 11?
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.
Hi, is there a way to display the different versions of the Microsoft Edge browsers for our computers? We would like to find out which of our users have the older "Classic" version of Microsoft Edge and the newer, Chromium-based version of Microsoft ...
I have tried to report video cards with this query:Select Top 1000000 tblComputers.Computer, tblDisplayControllerConfiguration.Caption From tblComputers Inner Join tblDisplayControllerConfiguration On tblComputers.Computername = tblDisplayControllerC...
Most of our computers have Kofax Power PDF installed. A number of PCs also have Adobe (Reader or Acrobat) installed. For the vast majority of PCs, Kofax is the default PDF program, but a small number of PCs have Adobe as default. I need a list of ...
