We need to build a report of VIP user requests.
We need to build a report of VIP user requests. Any advice on how to do this?
We are an organization of roughly 20k 'affected users', of those 20k users we probably have about 100 VIP customers that we need to take extra care of. Today, the only way that I have to know if they are being taken care of is to manually search for each user, and check if they have any pending requests.
What I would like, is to build a VIP Report that we can generate on the fly or scheduled that would show me any requests pending for any of those 100 individuals.
Our first thought was to build a some kind of SSRS report that we could populate off of an Active Directory group, our developers have been looking at a way to do that and thus far haven't had much success. The thinking is then we could just maintain a AD security group on the back end to monitor any requests related to them.
Any advice on how we can create such a report? Or any thoughts on how to accomplish this?