Pulling number of licenses for software out of the database.
Hi,
I'm currently writing an SQL script to pull the following information out of the database:
Name of installed software, Workstation the software is installed on, first name of the user associated with the workstation, number of copies of the software, number of licenses owned for the software.
I've managed to find the first three values in the database and construct an sql statement that pull them out. My problem is I can't find which table the number of licenses and installed copies of the software. This is the main piece of information I need. We are being audited very soon and unfortunately SD Plus doesn't provide us with a column indicating how many licenses we need for each piece of software, it just tells us how many licenses we have and how many copies are installed.
Could someone please let me know which table this information is kept in?
Thankyou
New to ADSelfService Plus?