Retrieving Database Creation date remotely using formula language ???

Posted on 2006-04-26
Last Modified: 2013-12-18
Hello all ,

I have a doubt regarding database modification date retrival remotely .

Suppose i have two databases on the same server.


now i want to show the modification/creation date of remotedb into a form/view of currentdb . But the restiction is that i can use only formula language .

Is there any solution you guys have ??

One more thing which i want to tell u that i got another solution of this , which uses "Catalog.nsf" in which we get all those databases information. But @dblookup command works only for first sorted column . While in second column (which is not sorted) is occupied by database name , which is useful for me in this case . but because of limitation of first sorted column i am not able to process that . Can u guide me in this direction also ??

Thanks in advance.
Question by:codeguru14
    LVL 63

    Expert Comment

    All you would need to do is to create a new view sorted the way you want and add the proper columns.

    You should do this on the Catalog template ( not the nsf ) so that the update in design are done automaticaly each night.

    I hope this helps !

    LVL 46

    Accepted Solution

    Use the ($ReplicaID) view, it is sorted on the replica ID of the database. I assume you can get any value from a document using
        @DbLookup(""; "server":"Catalog.nsf"; "($ReplicaID)"; ReplicaID; fieldname)

    Author Comment


    I am using such a server which has restricted access and i don't have permissions to create new views / documents .. So if there is any other solution excpet creating views , please share with me.


    I found it interesting , but the problem is that i don't have "ReplicaID" value with me . The value which i only know is the "database Name" and nothing else .
    Here is the view Selection formula for "$replicaId" view :

    SELECT @IsAvailable(ReplicaID)& @IsUnavailable(RepositoryType)

    So it means that ReplicaID must be available . But i don't know the ReplicaID of remote database except knowing its name .
    LVL 46

    Expert Comment

    by:Sjef Bosman
    Sorry, but no, that's not what it means. It means that only documents in that database are shown in the ($ReplicaID) view that match that condition: in the document there has to be a field ReplicaID and there must not be a field RepositoryType.

    From your point of view, this seems irrelevant. You need to get a ReplicaID for a database. How are you planning to program this? What remotedb are you talking about? You seem to have a Domino Designer available, what are you allowed to do with it?
    LVL 63

    Assisted Solution

    I would make a local replica of the Catalog DB, and create a view locally for the creation date.

    Other options are to use soe existing agents that gather info for you.


    The ACL scanner can easily be modified to get the data you need and will work locally.

    I hope this helps !
    LVL 18

    Assisted Solution

    Basically, create the two fields that you want to use to store the information in the currentdb.

    I used computed fields, one for modifiedDate and another for CreatedDate.

    Then I selected the remotedb, and did: File>>Database>>Properties, and copied the database name EXACTLY, and used that value in the LookupDB variable.  I used @Subset(@MaildbName;1) to get the server name, but you can also use @Subset(@DbName;1) provided that the current database is sitting on a server, else you will have to use:

    LookupDB:=@if(@Subset(@dbName;1)="";"Your Server Name";@Subset(@dbName;1))

    OK, this one will lookup the created date:
    LookupDB:="Test Web";
    @If(@IsError(CreatedDate)|CreatedDate="";"Not Found";@Text(CreatedDate;"D0S0"))

    This one will get the modified date:

    LookupDB:="Test Web";
    @If(@IsError(ModifiedDate)|ModifiedDate="";"Not Found";@Text(ModifiedDate;"D0S0"))

    Also, there is a chance that there is more than one database replica stored for the database, and in that case you will get two or more answers.  

    In this case, you modify the last line:
    @If(@IsError(ModifiedDate)|ModifiedDate="";"Not Found";@Text(ModifiedDate;"D0S0"))

    To do this:
    Result:=@If(@IsError(ModifiedDate)|ModifiedDate="";"Not Found";@Text(ModifiedDate;"D0S0"))

    As long as you get the Database Title correct, this should work.

    BTW, you can also get the replica ID of the database, by looking it up in the By Title view of Catalog.nsf, or, if it's available, selecting File>>Database>>Synopsis, then clicking on "Check DB Info", and then checking "General Information" and "Replication" check boxes.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now