Querying PC & Setting Local Admin

[CyberCitizen]

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.

[Esben_D]

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]

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

[CyberCitizen]

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?