Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
Filter out NULLS
mrdaytrade
#1 Posted : Thursday, May 20, 2010 7:50:05 PM


Rank: Premium user

Groups: Premium Users
Posts: 89
Location: Albany, NY
I would like to run this report, but have it only show the results if a value is present in dbo.tblRegistry.Value


Select Distinct Top (1000000) dbo.tblComputers.Computer,
dbo.tblComputers.Description, dbo.tblComputers.Username, dbo.tblRegistry.Value
As [Search Box], dbo.tblRegistry.Lastchanged, dbo.tblComputers.LastknownIP
From dbo.tblRegistry Inner Join
dbo.tblComputers On dbo.tblComputers.Computername =
dbo.tblRegistry.Computername
Where
dbo.tblRegistry.Regkey Like
N'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters'


Thanks in advance.
Lansweeper
#2 Posted : Friday, May 21, 2010 7:16:47 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,379
Try this:
Code:
Select Distinct Top (1000000) dbo.tblComputers.Computer,
  dbo.tblComputers.Description, dbo.tblComputers.Username, dbo.tblRegistry.Value
  As [Search Box], dbo.tblRegistry.Lastchanged, dbo.tblComputers.LastknownIP
From dbo.tblRegistry Inner Join                     
  dbo.tblComputers On dbo.tblComputers.Computername =
    dbo.tblRegistry.Computername
Where (dbo.tblRegistry.Value <> '' And Not dbo.tblRegistry.Value Is Null) And
  dbo.tblRegistry.Regkey Like
  N'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters'
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba