→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
CyberCitizen
Honored Sweeper
Hi Guy's

Hoping you can help. The environment I am using Lansweeper in, there are quite a few machines that do not have their local admin account enabled or password set. I have pushed this out to the computers a few times, but not everyone is online at the same time etc.

We have a deployment package setup that creates the accounts, sets the password etc. As part of the install package, it writes the following registry key once completed.

HKEY_LOCAL_MACHINE\SOFTWARE\lansweeper\AdminAcctEnabled with a DWORD value of 1.

I have created a custom registry scan location for this key.

What I am looking at creating now is a report that shows computers that do not have this key or value of 1.

This will be used as a scheduled deployment so that if the computer when scanned doesn't have this key or the value of 1, it would run the deployment package which creates the local admin account, enables it, sets the password etc.

The only issue is I am not the best with the SQL reports and couldn't find any examples of a report that is based on a missing registry key etc.

Any help would be greatly appreciated.
3 REPLIES 3
Esben_D
Lansweeper Employee
Lansweeper Employee
You can use the report from the following forum thread: https://www.lansweeper.com/Forum/yaf_postst10451_Value-of-a-value-name-submitted-for-custom-registry-scanning.aspx#post39295

Just replace the registry path and the name of the value.
heybobby1
Engaged Sweeper III
Try this

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblRegistry.Value,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Value Not Like '1' And tblRegistry.Valuename = 'AdminAcctEnabled' And tblAssetCustom.State = 1
heybobby1 wrote:
Try this

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblRegistry.Value,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Value Not Like '1' And tblRegistry.Valuename = 'AdminAcctEnabled' And tblAssetCustom.State = 1


Hey heybobby1,

Thank you for that, I have just run it, however it returned no results.

Do you have any other suggestions?