cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
RobinPSU
Engaged Sweeper
I found a report that will display Windows systems only. Is there a report that can be run to display all operating systems that are set with static IP Addresses? I tried manipulating an old report from another forum discussion but no luck. Once I tried to add the other operating system the entire report fails. I could be missing something. It seems like this is something folks would want already. Is there a built-in script or one that has been used successfully? I have 85 Windows machines that show up statically assigned but no clue about my Mac or Linux computers. Thank you for your help.

Daniel B wrote this in 2014 but it only display Windows systems:

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
0 REPLIES 0