Select Sys.Name0, Sys.SMSID0, Sys.Domain0, Sys.SystemRole0 from
dbo.v_GS_SYSTEM Sys Where Sys.SMSID0 = @GUID
Prompt for GUID:
select SMS_Unique_Identifier0 from v_R_System
Select Sys.Name0, Sys.SMSID0, Sys.Domain0, Sys.SystemRole0 from
dbo.v_GS_SYSTEM Sys Where Sys.SMSID0 = @GUID
Prompt for GUID:
select SMS_Unique_Identifier0 from v_R_System
This query did not work for me, need a help.
how are you providing the GUID ? you should supplay GUID in report prompt ?
what is not working for you ?
Hey Eswar this query did not work for me/..
how are you providing the GUID ? what is not working for you ?