Hi ADSM-ers!
My manager asked me to start charging our customers for ADSM usage. I
checked the Administrator Guide and came across the Accounting feature which
allows you to create accounting records. This is however at a session level
and only viable if you want the user to be charged for every byte which was
send to the server.
I would like to charge the user for the amount of Mb.'s stored on the server
and I'm going to collect this once a week (in the beginning).
I was thinking of updating the nodes contact field with an 4 digit account
code which I can use for processing. So, if a node is called "ERIC" and the
contact information is now: "Eric van Loon" I will change it to: "0761-Eric
van Loon" where 0761 is the account code for ERIC's department.
I am looking for an SQL query which I can use for collecting this data. It
would be great if it's possible to have the following output:
0761,ERIC,1075
where the first value is the account code (extracted from the contact
information), the second is the node name and the third is the amount of
stored megabytes.
Is this possible? Any help of you SQL wizards out there is VERY much
appreciated!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines