Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper II
Can somebody please help me, I've tried to get good at this darn SQL, but I'm not unfortunately.

I would love a report that can do the following:
Hard Drive < 10%
Offline for >7 days
Memory < 8GB
Assets without an owner
Anti-virus not enabled
Asset is Windows and purchase date > 5 years ago.
Operating System is not Windows Enterprise.
Application Identity service is not running (AppLocker)
Hard drive is not SSD, and asset is not a server.
Asset is tablet or laptop and local drives are not encrypted.
Performance Base Score is < 5
If Windows asset has Shared folders, aside from C$, and asset is not a server.
If Windows asset does not have a TPM.

I don't even know where to start, but this is my list of things that'd be nice for Lansweeper to generate.

Thanks in advance

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now