Hi folks,Not sure if its just me, but my OS: Not latest Build of Windows 10 report also llists those machines that are on 21H2.I would have expected those to be excluded from the report as 21H2 is the latest build - unless I am missing something obvi...
Hello,I need to actively manage and report on all our users who have admin rights on their local computers. The reporting on here is fine for Windows machines, but is there any way to scan and get a list of adminstrators on our Mac computers?Thanks ...
Hi Folks,Is there any way to detect if an Anti-Virus product is installed and its definitions up to date on an Apple Mac? The asset info for Windows machines makes it really easy, but I can't see this info on our Mac's.I could even live with running...
Hi Folks,Can you add an option to exclude a device based on Mac address please? We, like most companies use DHCP, so blocking by IP address isn't feasible. Thanks!Ian
Thanks Erik, I know about that and have implimented it to an extent with the Mac Addresses of our Docking stations, but its not really a long term solution. Let me give you an example of what has just happened in the last week.I bought a brand new m...
I think you are going to need to pull that info from the tblADUsers. Link the username from tblAssets to the username on tblADUsers. I have updated your code. see if this helps:;Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysO...
No Problem. Select Top (1000000) tsysOS.Image As icon,tblAssets.AssetID,tblAssets.AssetName,Case tblSoftwareHist.ActionWhen '1' Then '+'When '2' Then '-'End As [+/-],tblSoftwareUni.softwareName As Software,tblSoftwareHist.softwareVersion As Version,(...
First of all - here is the SQL. Create a new report, give it an appropriate title for your needs.Select Top 1000000 tblADusers.Username As Username,tblADusers.IsEnabled As [Account Enabled?],tblADusers.whenCreated As [Account Created],tblADusers.Las...