cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Marc_Tobien
Engaged Sweeper
HI
I am having problems to create an asset list with


Assetname
RAM in GB
Memory in GB
Disk in GB
Manufacturer
Model
OSname
IP4 Adresse which have now a ping respond ( switcht on)

I can get IP Adresse but then I get also the IP 6 Adresse and in the moment I am delinting ist in excel by hand.
there must by a way to set a filter for IP4. IP numeric is not good because then I have to reconvert it in excel to IP format
Thank you
3 REPLIES 3
Marc_Tobien
Engaged Sweeper
THX RC62N
I found the IP addresses in the tblAssets and that works fine for me.
Do you know if there is a way to list only active IP addresses of PCs and servers that are running when I run the report? We always scan late at night to keep the load low?
I then filter in Excel the date of last seen
RCorbeil
Honored Sweeper II
You don't specify which IP address source you're trying to use. If it's tblAssets, as Andy.S's example offers, tlAssets.IPAddress should be the IPv4 address in normal dotted-quad format.

Since you also refer to IP addresses including the IPv6 address, I assume you're also pulling form tblNetwork. If so, from my inventory, where tblNetwork.IPAddress includes both IPv4 and IPv6 addresses, it's formatted either "IPv4 - IPv6" or "IPv4 , IPv6". Either way, there's a space after the IPv4 address that can be sought as a separator.
CASE
WHEN CharIndex(' ', tblNetwork.IPAddress) > 0
THEN Left(tblNetwork.IPAddress, CharIndex(' ', tblNetwork.IPAddress)-1)
ELSE tblNetwork.IPAddress
END AS IPv4Address
Andy_Sismey
Champion Sweeper III
Have a look at this thread , it gives you 85% of what your after :- https://www.lansweeper.com/forum/yaf_postst15067_Total-Space-and-Free-Space.aspx#post51173 , you just need to add the memory count like this :

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon16) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblDiskdrives.Caption,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 / 1024 As
numeric) As FreeGB,
Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric) As
TotalSizeGB,
Floor(Cast(Cast(tblComputersystem.TotalPhysicalMemory As bigint) / 1024 /
1024 As numeric)) As [Total Memory],
tblDiskdrives.Lastchanged
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric)
<> 0 And tblState.Statename = 'Active' And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
tblDiskdrives.Caption


Taken from this thread : https://www.lansweeper.com/forum/yaf_postst4172_Change-the-memeory-size-in-reports-to-MB.aspx#post19639