So in SQL you will see some of these ServerNALPaths relating to the
distribution points.
I always wind up with something like....
REPLACE(SUBSTRING(DPR.DPNALPath, CHARINDEX('\\', DPR.DPNALPath) + 2,
CHARINDEX('"]', DPR.DPNALPath) - CHARINDEX('\\', DPR.DPNALPath) - 3 ),'.
mydomain.com,'')
swhen I want to pull the server name out of the NalPath. They also write
that in the reports.
It seems there is a built in function that does the same thing.
dbo.fnGetSiteSystemName(DPR.DPNALPath) will return the server name. it is a
lot cleaner.
