cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
helpdesk_txt
Engaged Sweeper
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.

4 REPLIES 4
helpdesk_txt
Engaged Sweeper
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
Champion Sweeper II
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
Engaged Sweeper
many thanks it worked properly!
MikeMc
Champion Sweeper II
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