Re: System Date in a Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joseph Calabig [MSFT] (jcalabig_at_microsoft.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 11:53:13 -0800

You can also try queyring the data reported by "Operating System" through
Hardware Inventory.
It has a property called "LastBootupTime". This is enabled by default in the
SMS_DEF.MOF.
Hope this helps. 

-- 
Thanks,
Joseph Calabig
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jose Manuel García"
<josem.garcia.exts@REMOVE_CAPS_AND_INVALIDjuntadeandalucia.es.invalid> wrote
in message news:c2nl4c$o17$3@nsnmrro2-gest.nuria.telefonica-data.net...
> Hi,
> I'm trying to make a query to get the list of clients that haven't
restarted
> their PCs in the last 3 days. My point of reference to know that is the
> proccess "SMSS.EXE. So I look for Pcs which SMSS.EXE proccess is started
> since a determined day.
>
> That means that I must change the query every day to continue having Pcs
> without restarting in the last three days.
>
> Is there a way to fix the reference day to system date?
>
> Here is my query. As it can viewed, I have to change the day of reference
> (in this case is 8) to 9, 10, etc for each new day.
>
> select SMS_G_System_SYSTEM.Name, SMS_G_System_PROCESS.Name,
> SMS_G_System_PROCESS.CreationDate from  SMS_R_System inner join
> SMS_G_System_PROCESS on SMS_G_System_PROCESS.ResourceID =
> SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on
> SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where
> SMS_G_System_PROCESS.Name = "SMSS.EXE" and DATEPART(DD,
> SMS_G_System_PROCESS.CreationDate) < 8 order by
> SMS_G_System_PROCESS.CreationDate DESC
>
> I'm trying to explain myself the best I can, bau my english is not
perfect.
> Sorry.
>
> -- 
> Jose Manuel García Rodríguez
> T-Systems Eltec S.A.
> Técnico Residente en Hospital de Valme
> Ctra. Sevilla - Cádiz, s/n
> Sevilla
> España
>
> Tlf.: +34 95 501 5091
> E-Mail: josem.garcia.exts@juntadeandalucia.es
> Web: http://www.t-systems.es
>
>
>

Relevant Pages

  • Re: System Date in a Query
    ... You can use the GetDate() SQL function to get the current date ... My point of reference to know that is the ... So I look for Pcs which SMSS.EXE proccess is started ... > That means that I must change the query every day to continue having Pcs ...
    (microsoft.public.sms.inventory)
  • System Date in a Query
    ... So I look for Pcs which SMSS.EXE proccess is started ... That means that I must change the query every day to continue having Pcs ... without restarting in the last three days. ... Is there a way to fix the reference day to system date? ...
    (microsoft.public.sms.misc)
  • System Date in a Query
    ... So I look for Pcs which SMSS.EXE proccess is started ... That means that I must change the query every day to continue having Pcs ... without restarting in the last three days. ... Is there a way to fix the reference day to system date? ...
    (microsoft.public.sms.setup)
  • System Date in a Query
    ... So I look for Pcs which SMSS.EXE proccess is started ... That means that I must change the query every day to continue having Pcs ... without restarting in the last three days. ... Is there a way to fix the reference day to system date? ...
    (microsoft.public.sms.admin)
  • System Date in a Query
    ... So I look for Pcs which SMSS.EXE proccess is started ... That means that I must change the query every day to continue having Pcs ... without restarting in the last three days. ... Is there a way to fix the reference day to system date? ...
    (microsoft.public.sms.inventory)