
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-14-2016 11:46 AM
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.
then I can Join to other tables to get further information.
Sqlexpress and LanSweeper v.6022
many thanks in advance for any tips.
Labels:
- Labels:
-
General Discussion
4 REPLIES 4

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2016 12:05 PM
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.
do you knwo how and what table JOIN to get out their Virtual Host?
many thanks.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2016 08:16 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2016 11:57 AM
many thanks it worked properly!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2016 09:36 PM
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
