|
Something like this?
select c.name,
c.[ip address],
s._eventTime,
_forward,
EventType,
AdvertisementId,
AdvertisementName,
PackageId,
Time,
Status,
FirstRun,
Message
from dbo.Evt_AeX_SWD_Status s
join vComputer c
on s._resourceguid = c.guid
where c.name = '%CN%'
or c.[ip address] = '%IP%'
You could then create 2 paramaters called CN and IP, use basic parameter types, value type of string.
|
