Ya! That got me where I need to go....simply just add the /1048576 or /1073741824 How could I add a GB or MB after the returned value?
To show like 32 GB? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Linkey, Mike Sent: Friday, January 03, 2014 3:00 PM To: mssms@lists.myitforum.com Subject: [mssms] RE: SQL query question - convery to GB or MB I am not in front of a SQL server, but I think this will get you MB. select Netbios_Name0 as 'Server Name', Description0, InitialSize0*1024 as ' Page File Initial Size', MaximumSize0*1024 as 'Page File Max Size', TotalPageFileSpace0*1024 as 'Total Page File Space', TotalPhysicalMemory0*1024 as 'Total Physical Memory' From v_R_System VRS Join v_GS_PAGE_FILE_SETTING PFILE on PFILE.ResourceID = VRS.ResourceID JOIN v_GS_X86_PC_MEMORY MEM on MEM.ResourceID = VRS.ResourceID From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Dzikowski, Michael Sent: Friday, January 03, 2014 1:56 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] SQL query question - convery to GB or MB 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' From v_R_System VRS Join v_GS_PAGE_FILE_SETTING PFILE on PFILE.ResourceID = VRS.ResourceID JOIN v_GS_X86_PC_MEMORY MEM on MEM.ResourceID = VRS.ResourceID [cid:image001.png@01CF0895.0E71EBD0] I saw John Nelson has a post on this, but was wondering if there was a different way: http://myitforum.com/myitforumwp/2011/11/02/sql-function-convert-bytes-to-kb-mb-gb-tb-pb-or-eb-and-format-the-output-to-human-readable-format/ Mike D-
<<inline: image001.png>>
