not sure how to ask this, but, I've got an internal customer who has to grab a lot of data from a SCCM view. Specifically the v_R_User view. All of the columns are generated in the DB by AD attributes, one of them being the Manager field. We're using SQL
Reporting and when the data from the column is displayed it's displayed exactly as it is in the column. thus the column data reads as the distinguished name and I'd like it to be displayed in the report as just the manager's name. Not a SQL guru, so
not sure how ot go about doing this. Any help will be greatly appreciated.
View Complete Post