How to display SMS query results in a SMS report

[owenhawk]

I have some very nice SMS queries that I want to display in SMS reports. I notice that you have to convert alot of the code to get this to work. I see a view in SMS reports called v_Query and I thought it might be used to display the results of a already created SMS query. Is anyone familiar with v_query if it could be used here?

Basically my query lists all devices with blank serial numbers and the computer name:

select distinct SMS_R_System.Name, SMS_G_System_SYSTEM_ENCLOSURE.SerialNumber from SMS_R_System inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.SerialNumber is NULL order by SMS_R_System.Name, SMS_G_System_SYSTEM_ENCLOSURE.SerialNumber

I want to be able to do this query as a report. Thank you very much for any assistance.

stephen hawkins

 

[DennisZhao]

I had the same problem. I worked around it by copying and pasting the sql commands from the query, and substituted all the codes from the query with the codes from report. Leave the sql commands the same. That should work, don't know if there is a easier way.