→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎02-02-2020 10:22 AM
‎03-03-2020 11:28 PM
‎03-03-2020 02:31 AM
‎03-03-2020 12:58 AM
‎03-03-2020 02:19 AM
CyberCitizen wrote:
Can you share your SQL / Deployment Report?
Just interested in how you're filtering the registry info.
I have done it with files, registry I am having a look at but always find it helpful to analyse code.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
DateDiff(n, tblAssets.Lastseen, GetDate()) As MinutesSinceLastScanned,
tblIMEI.IMEI
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value As IMEI
From tblRegistry
Where tblRegistry.Valuename Like 'IMEI' And Len(tblRegistry.Value) <>
15) tblIMEI On tblAssets.AssetID = tblIMEI.AssetID
Where tblAssetCustom.State = 1 And
DateDiff(n, tblAssets.Lastseen, GetDate()) < 60
Group By tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
DateDiff(n, tblAssets.Lastseen, GetDate()),
tblIMEI.IMEI
‎03-03-2020 12:11 AM
‎03-03-2020 12:31 AM
ghelpdesk wrote:
There are 3 steps in the package. 1st grabs the IMEI. 2 & 3 catch error states. You might not need steps 2/3 but we found it helped see laptops with wwansvc service issues.
Lansweeper scans regpath HKLM\Software\IMEI and regvalue IMEI.
‎02-04-2020 07:13 AM
‎02-03-2020 02:20 AM
‎03-02-2020 03:31 AM
ghelpdesk wrote:
We run the command CyberCitizen mentions and save the value into a registry key that Lansweeper scans so we can then reference in Lansweeper reporting and also drive automated deployment of the package if the value is not known (and the model is expected to have an IMEI value).
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now