SQL and Strings

This question was asked yesterday

“…The SiteSystem and SiteObject columns return data that looks like this:

MSWNET:\\Server\Share\

What I expect to see, (what I see in the console) is this:

\\Server\Share

Can anyone point me in the correct direction?”

Here is the answer

Select
replace (left(SiteSystem,charindex(‘MSWNET’,SiteSystem)-3),'[“Display=’,”),
SiteCode,
replace (left(SiteObject,charindex(‘MSWNET’,SiteObject)-3),'[“Display=’,”) as ‘Storage Object’,
Role,
cast (BytesTotal/1024/1024 as varchar) +’ GB’as “Total Space”,
cast (BytesFree/1024/1024 as varchar) +’ GB’as “Free Space”,
cast (PercentFree as varchar) + ‘%’ as “Percent Free Space”,
DownSince
From
v_SiteSystemSummarizer SSS
Where
Role = ‘SMS Distribution Point’

Leave a Reply

Your email address will not be published. Required fields are marked *