cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kamidon
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
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

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

Try Now