Re: IP Address
- From: "Steve Thompson" <stevethompson@xxxxxxxxxxxxx>
- Date: Thu, 28 Dec 2006 12:54:17 -0500
"Jay (Work)" <nomorespammer@xxxxxxxxxxxxx> wrote in message
news:56710442-BE46-4ACF-B062-13695F93B854@xxxxxxxxxxxxxxxx
It seems SMS stores last 3 IP addresses in SQL.. the SMS Client properties
shows IPAddress(0), IPAddress(1) and IPAddress(2). How can I get the
latest/current IP from SQL?
Hi Jay,
This is an example of a query that we use for collections to determine
membership to a specific subnet. Replace the x, y & z variable to get all
machines on a specific subnet.
select
SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client
from SMS_R_System where IPSubnets like "%x.y.z%"
Change that one a bit and here is one that returns the system ip address,
which would be as current as the last hardware inventory:
select SMS_R_System.ResourceId, SMS_R_System.ResourceType,
SMS_R_System.IPAddresses, SMS_R_System.Name,
SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup,
SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SYSTEM on
SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_SYSTEM.Name = "computername"
.
- References:
- IP Address
- From: Jay \(Work\)
- IP Address
- Prev by Date: IP Address
- Next by Date: inventory runs but server shows only badmifs
- Previous by thread: IP Address
- Next by thread: inventory runs but server shows only badmifs
- Index(es):
Relevant Pages
|
