I've seen posts regarding local administrative accounts; however, I need to be able to provide a report for all local user accounts (regardless if they have admin priveleges or not).
I make a report to get all the Antivirus software instaled.Here's the code:SELECT TOP (1000000) tblSoftware.softwareName AS Software, COUNT(tblcomputers.ComputerUnique) AS EquiposFROM tblcomputers INNER JOIN tblSoftwa...
Hi,i'm trying to generate a report which is showing me all local admins (local admins + domain admins + users which are added to the local administrators group) on my servers.I've already build a report which only shows me the local users (16 times!)...
Hello,is there a way to query the size of the harddisk?Everything I've found gives me only the size of the partitions on the disk not the size of the harddisk itself.Greetings, Stephan
I have this custom reports that is used to get a list of all active computers with some specific where clauses.Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputersystem.Lastchanged, Web40OSName.Compimage As icon, tb...
