‎08-29-2019 09:37 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblADusers.Firstname,
tblADusers.Lastname,
SubQuery1.Value As [Registry Value],
tblAssets.Firstseen,
SubQuery1.Lastchanged,
tblAssets.Lastseen As Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where
tblRegistry.Regkey Like
'%SYSTEM\CurrentControlSet\Control\Session Manager\Environment' And
tblRegistry.Valuename = 'JAVA_TOOL_OPTIONS') SubQuery1 On
SubQuery1.AssetID = tblAssets.AssetID
Inner Join tblADusers On tblADusers.Username = tblAssets.Username
Where tblAssetCustom.State = 1 And TsysWaittime.CFGname = 'registry'
Order By tblAssets.AssetName
Solved! Go to Solution.
‎09-06-2019 04:17 PM
User18954 wrote:
I had the same issue and made my SQL as simple as possible.
I was reporting strictly on NAS units, not Windows units to do a WOL and it failed.
So I added 1 PC into the mix of NAS units and it took it. So it deploys now.
Still have to test if it really does WOL on the NAS units at a set time (due to power losses and the NAS units themselves BIOS not WOLing after power loss).
So in my WHERE clause i just added everything in parenthesis then did an OR IPADDRESS like '192.168.1.100' (which is my PC) so it picked up 1 Windows 10 PC in the mix of my NAS units.
‎09-06-2019 03:36 PM
‎09-06-2019 04:17 PM
User18954 wrote:
I had the same issue and made my SQL as simple as possible.
I was reporting strictly on NAS units, not Windows units to do a WOL and it failed.
So I added 1 PC into the mix of NAS units and it took it. So it deploys now.
Still have to test if it really does WOL on the NAS units at a set time (due to power losses and the NAS units themselves BIOS not WOLing after power loss).
So in my WHERE clause i just added everything in parenthesis then did an OR IPADDRESS like '192.168.1.100' (which is my PC) so it picked up 1 Windows 10 PC in the mix of my NAS units.
‎08-30-2019 08:24 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now