|
Bah...
I used the tables in my database... Let me rewrite the query to use what Tom was using.
SELECT _ResourceGuid,
T1.[Name],
CASE
WHEN LASTBootUpTime='' THEN NULL
WHEN SUBSTRING (LastBootUpTime,11,1) = 'T' THEN CONVERT (Datetime, LastBootUpTime, 126)
ELSE CONVERT(Datetime, SUBSTRING(LastBootUpTime,1,4) + '-' + SUBSTRING(LastBootUpTime,5,2) + '-' + SUBSTRING(LastBootUpTime,7,2) + 'T' + SUBSTRING(LastBootUpTime,9,2) + ':' + SUBSTRING(LastBootUpTime,11,2) + ':' + SUBSTRING(LastBootUpTime,13,2), 126)
END AS 'Boot'
FROM AeX_OS_LastBootUpTime T0
INNER JOIN [Inv_AeX_AC_Identification] T1 ON T1.[_ResourceGuid] = T0.[_ResourceGuid]
See if that doesn't work for you.
__________________
Scire potentia est (knowledge is power)
|
