How to Automate Database informations

Business Central/NAV User Forum
1

Hi

I am trying to automate the database informations which i take every week. I normally take this manual route.

File->Database->Information and then click on Table tab to get the database table.

I normally take only the no. of record informations for each table. I have selected some tables which i am interested on for the information.

How can i do this process automatically. I was trying to develop a report to do it bit it does not work because the database information is not a dataitem.

Can somebody help me on how to do this?

Thanks in Advance.

2

You can create a report using virtual table 2000000028 (Table Information).

3

I also would like to have informations about the database size used, %database size, database size and the licensed size as well in the same report.

How can table 2000000028 (Table Information) give me those underlined information on one report.

Database Size Used(GB)

Database Size Used(GB)

4

The size you get from table Database File (2000000010).

Licensed size and database size you can put in on the RequestForm of the report (and if you set the SafeValues-property you just have to modify these values from time to time)

5

Table Database File (2000000010) is only giving me The database size and the rest of the information i don’t need. How do you think i can get all the information as as mentioned earlier with underline.

I would be happy if i can get a sample report from you that can does what i want. Any sample code or report please?

Thanks

6

Are you using SQL or Native?

If you are using SQL you could easily create a SPROC to send you that information once a week.

T

7

I am using Native version 4.0. I would love to have something that can enable me to have this report sent to me once every week.

Any ideas Please?

Thanks

8

You will have to get something to run a report each week. There are a number of posts about how to hook up reports to the Job Scheduler to schedule the running of reports.

You will probably also want to email the report to you as HTML - which will be a minor modification (do a search)

And if you’ll also probably want run the job scheduler without a client (run it with the NAS). Again, do a search for how to do that.

I think you’re going to find, that all in all, you’re better off with logging on and running your report.

9

I am presently try to get the report format. I am still not able to get the format as i indicated above from table. I will move to the sending of the report as e-mails after getting the report. But first can some one help me get the report in the format i indicated above. Any suggestions please?