Help with a simple SQL report
Updated: 09 Jul 2010 | 3 comments
This issue has been solved. See solution.
Hi,
I'm trying to bring in the computer model into a report I put together showing BIOS version times.
I can't seem to get the join working for the model, though it's working for the other field.
Any advice? The code at the bottom has to do with a collection picker.
SELECT vc.Name as 'Computer Name', arp.[Bios Release Date] as 'Release Date', mdl.[Computer Model] as 'Model'
from vComputer vc
join Inv_Aex_HW_BIOS arp on arp._ResourceGuid = vc.Guid
join Inv_AeX_HW_Serial_Number mdl on mdl._ResourceGuid = vc.Guid
INNER JOIN dbo.CollectionMembership cm ON vc.Guid = cm.ResourceGuid
where cm.CollectionGuid ='%Collection%'
Thanks!
Discussion Filed Under:
Comments
I ran the query with a
I ran the query with a collection guid and it ran without errors running the computer name, bios date and model.
Steve Petrasek
Thank you! I was wondering
Why can't Altiris use standard SQL parameters
This %Parameter% thing is a PITA.
I build my SQL in SQL Server Management Studio and then paste in...It would be sooooo much simpler if Altiris would just use the @Parameter format.
Would you like to reply?
Login or Register to post your comment.