Restore Stock Report

[Malbanese]

I stupidly deleted the "Network: Static IP address configured" report. Is there a way i can restore it or could someone post the query for me.

Thanks

[Susan_A · Accepted solution]

Just an FYI for everyone: all built-in reports can now be found in the report center.

[Malbanese]

THANK YOU!

[Jono]

Here you go.

Select Top 1000000 dbo.tblAssets.AssetID,
  dbo.tblAssets.AssetUnique,
  dbo.tblAssets.Domain,
  dbo.tsysOS.Image As icon,
  dbo.tblNetwork.IPAddress,
  dbo.tblNetwork.IPSubnet,
  dbo.tblNetwork.Lastchanged
From dbo.tblAssets
  Inner Join dbo.tblNetwork On dbo.tblAssets.AssetID = dbo.tblNetwork.AssetID
  Inner Join dbo.tblAssetCustom On dbo.tblAssets.AssetID =
    dbo.tblAssetCustom.AssetID
  Inner Join dbo.tsysOS On dbo.tblAssets.OScode = dbo.tsysOS.OScode
Where (dbo.tblNetwork.IPAddress <> '0.0.0.0' And dbo.tblNetwork.IPAddress <> '')
  And dbo.tblNetwork.IPEnabled = 1 And dbo.tblNetwork.DHCPenabled = 0 And
  dbo.tblAssetCustom.State = 1
Order By dbo.tblAssets.AssetName