In this example, the requesting user is researching the Events_Media view for events associated with the user named ‘PAL’.
SELECT DataSetName,VolSerialId,DupeDumpSet FROM DBC.Events_MediaV WHERE UserName = 'PAL' ;
Result:
DataSetName VolSerialId DupeDumpSet ------------- ----------- ----------- BRM.DBC.TEXT1 000469 N BRM.DBC.TEXT1 000469 N BRM.DBC.TEXT2 000469 N BRM.DBC.TEXT2 000469 N BRM.DBC.TEXT1 BRM001 Y BRM.DBC.TEXT1 BRM002 Y BRM.DBC.TEXT2 BRM001 N BRM.DBC.TEXT2 BRM002 N