.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Marcum, John
Sent: Friday, January 03, 2014 3:46 PM
To: 'mssms@lists.myitforum.com'
Subject: RE: [mssms] SQL query question - convery to GB or MB
To add text into the cell you can do something like what I found here.
http://msdn.microsoft.c
rg
Sent: Friday, January 03, 2014 3:12 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] SQL query question - convery to GB or MB
Mike,
You can use ROUND in your Select statement and do the math there. For example,
replace TotalPhysicalMemory0 as
tforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Dzikowski, Michael
Sent: Friday, January 03, 2014 2:28 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] SQL query question - convery to GB or MB
Ah! Thank you. That got me closer.
So when I add this:
ROUND(MEM.TotalPhysicalMemory0 / 1024
.@ally.com<mailto:michael.dzikow...@ally.com>
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] SQL query question - convery to GB or MB
Date: Fri, 3 Jan 2014 19:56:23 +
How can I convert the results from this query to show in MB or GB?
select Netbios
om
Subject: [mssms] SQL query question - convery to GB or MB
Date: Fri, 3 Jan 2014 19:56:23 +
How can I convert the results from this query to show in MB or GB?
select Netbios_Name0
as 'Server Name', Description0, InitialSize0
as ' Page File Initial Size', Maxim
How can I convert the results from this query to show in MB or GB?
select Netbios_Name0 as 'Server Name', Description0, InitialSize0 as ' Page
File Initial Size', MaximumSize0 as 'Page File Max Size', TotalPageFileSpace0
as 'Total Page File Space', TotalPhysicalMemory0 as 'Total Physical Memory
6 matches
Mail list logo