SQL query to get all machines scanned or not.

[helpdesk_txt]

Hi all, does anybody know a query to get the fully list of scanned machines and not scanned machines?

then I can Join to other tables to get further information.

Sqlexpress and LanSweeper v.6022

many thanks in advance for any tips.

[helpdesk_txt]

another question please, I filtered the machine to get out only the VM ,, where Model like '%Virt%.

do you knwo how and what table JOIN to get out their Virtual Host?

many thanks.

[MikeMc]

helpdesk_txt wrote:
another question please, I filtered the machine to get out only the VM ,, where Model like '%Virt%.

do you knwo how and what table JOIN to get out their Virtual Host?

many thanks.

We don't have VMWare scanning set up in our environment, but a quick search of the forums reveals someone else put together a query to link hosts and guests, http://www.lansweeper.com/Forum/yaf_postst11441_All-Servers-VM-Uptime.aspx#post42543

[helpdesk_txt]

many thanks it worked properly!

[MikeMc]

This query will show active assets not scanned via IP address and the LSPush agent.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblAssets.LastIPScan Is Null And
  tblAssets.LastLsPush Is Null
Order By tblAssets.AssetName