Is it just a bad paste job, or are the quotes the bad kind? Each line has these quotes: ‘’ when it should be: ''
On Fri, Oct 7, 2016 at 11:17 AM Brian McDonald <[email protected]> wrote: > I'm aware I was missing the 'S' in Select in the below. Here is the FULL > query i'm running. [image: 😊] > > > SELECT > > cs.Name0 AS ‘ComputerName’, > DATEDIFF(HOUR, os.LastBootUpTime0, ws.LastHWScan) > AS ‘Uptime (in Hours)’, > CONVERT(VARCHAR(26), os.LastBootUpTime0, 100) > AS ‘Last Reboot Date/Time’, > CONVERT(VARCHAR(26), ws.LastHWScan, 101) > AS ‘Last Hardware Inventory’ > FROM > dbo.v_GS_WORKSTATION_STATUS ws > LEFT OUTER JOIN dbo.v_GS_Operating_System os > ON ws.ResourceID = os.ResourceID > LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM cs > ON cs.ResourceID = os.ResourceID > WHERE os.Caption0 LIKE ‘%server%’ > ORDER BY os.LastBootUpTime0 ASC > ------------------------------ > *From:* [email protected] <[email protected]> > on behalf of Brian McDonald <[email protected]> > *Sent:* Friday, October 7, 2016 10:55:41 AM > *To:* [email protected] > *Subject:* [mssms] Uptime and Last Reboot for Servers > > > Hello everyone, > > > I'm trying to determine the uptime and last reboot for servers. Below is > the query I am trying to execute: > > > ELECT > cs.Name0 AS ‘ComputerName’, > DATEDIFF(HOUR, os.LastBootUpTime0, ws.LastHWScan) > AS ‘Uptime (in Hours)’, > CONVERT(VARCHAR(26), os.LastBootUpTime0, 100) > AS ‘Last Reboot Date/Time’, > CONVERT(VARCHAR(26), ws.LastHWScan, 101) > AS ‘Last Hardware Inventory’ > FROM > dbo.v_GS_WORKSTATION_STATUS ws > LEFT OUTER JOIN dbo.v_GS_Operating_System os > ON ws.ResourceID = os.ResourceID > LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM cs > ON cs.ResourceID = os.ResourceID > WHERE os.Caption0 LIKE ‘%server%’ > ORDER BY os.LastBootUpTime0 ASC > > > I'm getting a syntax error, > Msg 102, Level 15, State 1, Line 2 > Incorrect syntax near '‘'. > > > Can someone tell me what I'm doing wrong? > > > Thank you, > > > Brian > >
