Remote Admin Databases

[laker_42]

When administrating a FMServer remotely, there are 3 databases. There is FM_Admin, FM_Usage & FM_Data. What is the FM_Data database supposed to show? Mine is only showing Host Minutes and nothing else. How is this database used? I can't get to it from the FM_Admin database can I? I know its there for a reason, I just haven't been able to figure out what that reason is.

Thanks,

John

[Anatoli]

Install admin plugin to your workstation. It is on server CD.

[EddyB]

Hi John,

The FM_Data Database is where the FM_Admin Database gets most of it's info from

When you lookt at the FM_Data Database you can only see the first record, which is the one you mentioned where it shows the Host Minutes, you will see in the top left that this is Record Type 5.

OK there are 4 other record types, depending on what is running at the time and who is connected affects what record types you will see in this database and also affects the number of records.

View the status bar of the FM_Data Database. You will probably see more records are loaded all with different record types.

Definitions of record types:

Record Type 1

Each guest connected to the host has a record in the FM_data database. These records are type 1

Record Type 2

Every time a guest opens a file a record is created. Type 2 records shows users and the files they have open.

Record Type 3

Hosted Folders are type 3 records

Record Type 4

Hosted Files are type 4 records

Record Type 5

This is what you saw, the hosted minutes - I think that this is how long the server has been hosting for - but thats not for definite!

Do not get confused though, this database does not get huge! The records created are deleted when the user closes the hosted databases

Scenario:

At present no-one is connected to your host, you are hosting 3 databases called DB1 DB2 and DB3 these are stored in a folder called DBS

The FM_data database will currently have 5 records

1 record type 5 - showing hosted minutes

3 record type 4 - showing hosted files (1 record for DB1, 1 record for DB2, 1 record for DB3)

1 record type 3 - showing hosted folders (DBS Folder)

OK, so now you open up DB1 on your client PC, 2 more records are created on FM_Data database:

1 record type 1 - showing you, the guest

1 record type 2 - showing that you, the guest, have open DB1

Now you close DB1

You are no longer connected to the server

So the 2 records just created are deleted

So we are back to 5 records, hosted minutes, hosted files, hosted folders.

All of the info above is what you view in FM_Admin, FM_Admin gets its data from FM_Data

Hope this makes things a bit clearer for you!

Ed.

[laker_42]

Ed,

That did makes things a bit clearer. A couple of questions in regards to what you said. Should I be able to look at those other records or can I only ever see the very first type 5 record? When I view the status bar, it doesn't show how many records there are and it greyed out the status area option.

Is this database's only function to feed the FM_Admin database? The user really isn't supposed to look at it because of that reason?

Thanks for the help!

John

[Anatoli]

It looks like I've misunderstood the question.

[EddyB]

Hi John,

I'm not sure why you cannot see the full list of records. Do you have the admin plugin installed on your workstation (as mentioned by Anatoli above)

If I understand correctly, you can view the databases without the plugin , but installing the admin plugin into your client workstation, you can administer the Databases you mentioned

Maybe this is the reason?

Let me know.

Ed.

[LuckyMe]

EddyB,

Is it anyway to serve multi files from Remote Admin Windows?

Right now I can UNSERVE the whole system by click the folder name that contains all files that have been serving, then click Close button. But when I need to serve it back I must to select one file to serve at a time only. And I have about 40 files to serve.

Any idea?