Notification

Icon
Error

Windows: Static IP address configured (Built-in)

Posted: Thursday, November 20, 2014 2:28:07 PM(UTC)
Daniel.B

Daniel.B

Member Original PosterPosts: 1,150
0
Like
Old name: Network: Static IP address configured (Built-in)

The report below lists all Windows computers having configured a static IP address

The report will only list assets that meet all of the following criteria:
  • The asset state is set to "active".
  • The asset has been successfully scanned at least once.
  • The asset is a Windows computer.
  • The asset has TCP/IP enabled.
  • The asset has a static IP address configured.
Code:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblNetwork.IPAddress,
  tblNetwork.IPSubnet,
  tblNetwork.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblNetwork.IPAddress <> '0.0.0.0' And tblNetwork.IPAddress <> ''
  And tblState.Statename = 'Active' And tblNetwork.IPEnabled = 'True' And
  tblNetwork.DHCPenabled = 'False'
Order By tblAssets.AssetName,
  tblAssets.Domain
RobinPSU
#1RobinPSU Member Posts: 2  
posted: 3/27/2020 8:52:12 PM(UTC)
What would one manipulate in order to do this for Linux and Mac Operating systems? Still including Windows OS as well.

Originally Posted by: Daniel.B Go to Quoted Post
Old name: Network: Static IP address configured (Built-in)

The report below lists all Windows computers having configured a static IP address

The report will only list assets that meet all of the following criteria:
  • The asset state is set to "active".
  • The asset has been successfully scanned at least once.
  • The asset is a Windows computer.
  • The asset has TCP/IP enabled.
  • The asset has a static IP address configured.
Code:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblNetwork.IPAddress,
  tblNetwork.IPSubnet,
  tblNetwork.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblNetwork.IPAddress <> '0.0.0.0' And tblNetwork.IPAddress <> ''
  And tblState.Statename = 'Active' And tblNetwork.IPEnabled = 'True' And
  tblNetwork.DHCPenabled = 'False'
Order By tblAssets.AssetName,
  tblAssets.Domain


Active Discussions

Lansweeper Version 10.2.0.0
by  _Shawn_   Go to last post Go to first unread
Last post: 7/1/2022 10:33:33 PM(UTC)
Lansweeper Certificates
by  Orion Poplawski  
Go to last post Go to first unread
Last post: 7/1/2022 10:11:12 PM(UTC)
Lansweeper Dell warranty lookup not working
by  LANGuy  
Go to last post Go to first unread
Last post: 7/1/2022 1:30:06 PM(UTC)
Lansweeper RedHat 8.5 & SELinux
by  QuelleAcht   Go to last post Go to first unread
Last post: 7/1/2022 1:16:19 PM(UTC)
Lansweeper Suddenly seeing Access Denied scanning errors?
by  Erik.T  
Go to last post Go to first unread
Last post: 7/1/2022 9:38:17 AM(UTC)
Lansweeper Single Line report with H/D
by  Ioannis   Go to last post Go to first unread
Last post: 7/1/2022 7:53:23 AM(UTC)
Lansweeper Lansweeper Dark Theme
by  mrobbins  
Go to last post Go to first unread
Last post: 6/30/2022 5:38:01 PM(UTC)