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