cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
284
Views
0
Helpful
0
Replies

iCPAM query

ariel.quintana
Beginner
Beginner
Hello, I have this Query, which filters badges without events for X days.
I need to add to this report the name and ID of the person assigned to the badges.
Do you know how I could do that?

 Query

select b.card_num from vx_badge b left join vx_cred c on b.unid = c.unid where b.unid NOT IN (select cred from vx_evt where evt_type_id in ('EVENT') and logcode_id in ('GW.EV_DOOR_GRANT_ACCESS', 'GW.EV_DOOR_DENY_ACCESS_NO_ACC') and cred IS NOT NULL and evt_time >= DATE_SUB(NOW(), INTERVAL 30 DAY)) and c.validity_type='VX.ACTIVE' order by card_num;

regards

0 Replies 0
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers