SQL question: I'm trying to put together a report for our helpdesk to use which
will allow them the ability to confirm that a specific user is matched up to
the right device. This below works in SQL studio but it requires that I use
wildcards in the where statement. When building the report, I need that to be a
prompt/parameter. How do I write this so the @userid variable has wildcards
around it when it runs? Or if anyone has a better way of reporting on this, let
me know. I didn't see a built-in report for a specific user, only for users in
a specific collection. Maybe I missed it though...
select upm.UserResourceID,
upm.MachineID,
vru.Name0 as [User Name],
vrs.Name0 as [Machine Name]
from v_UsersPrimaryMachines upm
left join v_R_User vru on upm.UserResourceID = vru.ResourceID
left join v_R_System vrs on upm.MachineID = vrs.ResourceID
where vru.Name0 like @userid
Thanks,
James
________________________________
IRS Compliance: Any tax advice contained in this communication (including any
attachments) is not intended or written to be used, and cannot be used, for the
purpose of (i) avoiding penalties imposed under the Internal Revenue Code or
applicable state or local tax law or (ii) promoting, marketing, or recommending
to another party any transaction or matter addressed herein.
________________________________
Confidentiality Notice: This e-mail is intended only for the addressee named
above. It contains information that is privileged, confidential or otherwise
protected from use and disclosure. If you are not the intended recipient, you
are hereby notified that any review, disclosure, copying, or dissemination of
this transmission, or taking of any action in reliance on its contents, or
other use is strictly prohibited. If you have received this transmission in
error, please reply to the sender listed above immediately and permanently
delete this message from your inbox. Thank you for your cooperation.
