+1In our environment we currently have devices named by what building they are part of in SCCM. For example WUES-12337.
In the sync executable for SCCM how can we grab the “WUES” or even “WUES-” portion of the string and set it as the location data for the import from SCCM?
Thank you!
Best answer by ZLacy 550f1be wcsk12
I was able to figure it out. Here is what I used incase anyone needs it in the future:
SUBSTRING (SYS.Name0,0,CHARINDEX('-',SYS.Name0)) AS LocationName,
+18Are you importing via CSV file? I am not sure you are able to accomplish this but let’s see what we can do!
+1No, not importing via CSV for this. I think we just need to adjust the SQL (or at least I am assuming it is SQL) in the SCCM syncing app. I feel substring and charindex will come into play, but I am unfamiliar with SQL syntax.
Thank you for the response!
+1I was able to figure it out. Here is what I used incase anyone needs it in the future:
SUBSTRING (SYS.Name0,0,CHARINDEX('-',SYS.Name0)) AS LocationName,
+18Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
