Re: Find all systems in a specific subnet

Try this..
SELECT DISTINCT
v_GS_COMPUTER_SYSTEM.Name0 AS 'PC Name',
v_GS_COMPUTER_SYSTEM.UserName0 AS 'User Name',
v_GS_NETWORK_ADAPTER_CONFIGUR.DefaultIPGateway0 as 'Gateway'
FROM
v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM,
v_GS_NETWORK_ADAPTER_CONFIGUR v_GS_NETWORK_ADAPTER_CONFIGUR
WHERE
v_GS_NETWORK_ADAPTER_CONFIGUR.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID
AND ((v_GS_NETWORK_ADAPTER_CONFIGUR.DefaultIPGateway0 Is Not Null))
AND (v_GS_NETWORK_ADAPTER_CONFIGUR.DefaultIPGateway0 = '10.1.110.1'
OR v_GS_NETWORK_ADAPTER_CONFIGUR.DefaultIPGateway0 = '10.13.88.254')


"Jay (Work)" <nomorespammer@xxxxxxxxxxxxx> wrote in message
news:894944AC-E728-4157-8B59-824479E471D3@xxxxxxxxxxxxxxxx
Hello all -

SMS 2003 SP1, need to report on systems counts per subnet. Any help would
be appriciated.
Thank you
Jay


.

Relevant Pages

  • RE: Status Report Notification
    ... \par For the SQL installation of Project Server SP1, confirm that the correct .sql files are installed on the system. ... \par If you would like to check the database to see whether the status report is still in the dataset, you can try the below query in Query Analyzer: ... \par Jay, MCP ...
    (microsoft.public.sharepoint.teamservices)
  • Find all systems in a specific subnet
    ... SMS 2003 SP1, need to report on systems counts per subnet. ... Jay ...
    (microsoft.public.sms.admin)
  • find all systems on subnets
    ... SMS 2003 SP1, need to report on systems counts per subnet. ... Jay ...
    (microsoft.public.sms.inventory)
  • Re: Process Store.exe Alert Stuck?
    ... I am receiving one report every 24 hours plus or minus a minuet or two. ... install of SP1 for SBS2003. ... Is Exchange server 2003 SP1 installed on the SBS ...
    (microsoft.public.windows.server.sbs)
  • Re: Liberty Swing
    ... >> I haven't seen any report on the Liberty Swing event that took place last ... good job of jump-starting the event to a high energy level. ... Ed Jay ...
    (rec.arts.dance)