I have a report unauthorized local admins on pc's. I'm looking to also filter out ((User X on PC Y) and (user W on PC Q)) from the report. I can't seem to make it work though.Current report:Select Top 1000000 tblAssets.AssetName, tblUsersInGroup.A...
I like the ability to find rogue devices. We do have scanner servers deployed to remote subnets for deployment/scanning/etc. But the intro to asset radar sounds much more appealing with how it can detect rogue devices. But yet none of the document...
I'm trying to query devices that are a part of an AD group to see if they're missing a specific registry key.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tsysOS.O...
I've tried creating and running deployments, but they never execute on the endpoint. I keep thinking it's a permissions deal. Possibly running the deployment as system isn't correct/working..
It changed to the following when I saved.. but seems to work. Thanks!!And (Not tblUsersInGroup.Username = 'User X' Or Not tblAssets.AssetName = 'PC y')
We're having many deployment issues after the upgrade..then after applying this last "fix" as well! I had to disable all our deployments as some were randomly kicking off against random assets when I'd deploy a different package to a single asset!Ev...
I like the report. Though I'm not sure I'm seeing accurate results. I manually performed windows updates against the Microsoft cloud on 2 windows 7 enterprise pc's. Both have been fully patched. The report however says they're missing KB4462923. ...
I think I figured it out.. it's probably ugly and could be more efficient, but I'm not a DBA!Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.AssetName, tblAssets.Domain, tblAssets.I...
