I have a query to collect occurances of a particular Event ID but I would like to only see one instance of each computer that is having the problem, not a listing for every trigger in the event log.Any suggestions on fixing my query?Select Top 100000...
HelloI am trying to create a new report which gets every logon on every machine.Now i've put an SQL string together with those infomation:Select Top 1000000 tblAssets.AssetID, tblCPlogoninfo.logontime, tblAssets.AssetName, tsysAssetTypes.AssetType...
I would like generate a user-based Report which Shows me the following Information:User - > Computer name -> Pc Age -> Hardware -> Installed SoftwareAny help will be appreciatedThanks
Hi I need a bit of help with a report that lists all the Microsoft security patches installed on my company assets. I would like to be able to only include servers that are listed as domain controllers. Any help is appreciated!Select Top 1000000 tb...
Hello everybody,I'm a new happy user of LanSweeper Premium I'm not really familiar with SQL but testing quickly, I see that I can not set up a query that will display (for example) all my machines WITH and WITHOUT 'Microsoft Office%'. > In the same q...
Has anyone configured Lansweeper to show somehow if McAfee FDE Encryption is installed? I found an old SCCM article giving some insight but it is 3 years old.
