Jump to content

Deducing Unused Databases


JLC10123
 Share

This topic is 2852 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Greetings! I've inherited an instance of FileMaker Server 12 that is hosting 100+ files, and 80% of them haven't been used or even logged into in years. 5% are used regularly, and 15% are used very occasionally. The issue is I haven't the foggiest idea which is which.

 

Does anyone have any clever ideas on how I could, in one fell swoop, figure out which ones have fallen out of use?

 

Are there database file properties hiding somewhere? In a perfect world, I would like to know:

  • The date any user last logged into a file;
  • The date any user last edited any data in the file;
  • The account name of those users;
  • The date the file was actually hosted.

(I realize the answer is probably no, but I can dream, right? And there has to be SOME way to figure this out besides asking 500 people which databases they use...) Any and all ideas are welcome. Thanks!

 

- Joy

 

Link to comment
Share on other sites

I would be cautious with the previous suggestion.. if their are 100+ files on the server then chances are that their is interconnected data. Turining off one file could cause huge issues with data that you may not be able to fix. Quick fix? probably not.

Link to comment
Share on other sites

Fear not, I wouldn't have done it. But I definitely did get a good chuckle out of it, so many thanks to you, WorldWatcher. :-P

 

It was Deja Vu, I was talking to our DB Administrator in IT last week and she was talking about the same thing.  When I discribed the Squeaky Wheel Script she burst out laughing.  :))

 

>>>>

Link to comment
Share on other sites

This topic is 2852 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.