Custom Query - Alias for column name
Hi Excuse me for the question but...can you provide an example about using alias for column in a custom query? I tried with column_name AS alias_name but SCCM prompt me about syntax warning. Thanks Regards
March 22nd, 2010 6:46pm

I have the following query: select SMS_R_System.Name, SMS_R_System.IPAddresses, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserName, SMS_G_System_OPERATING_SYSTEM.Caption, SMS_G_System_OPERATING_SYSTEM.CSDVersion from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT%Workstation%" I want that column name "SMS_R_System.Name" will be display with "Name" , SMS_R_System.IPAddresses with "IP Address" and so on...
Free Windows Admin Tool Kit Click here and download it now
March 22nd, 2010 6:58pm

you can use like select SMS_R_System.Name As "Name", SMS_R_System.IPAddresses AS "IP Address", SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserName, SMS_G_System_OPERATING_SYSTEM.Caption, SMS_G_System_OPERATING_SYSTEM.CSDVersion from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT%Workstation%"
March 22nd, 2010 7:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics