Holy cow, I wrote a book!
Internally at Microsoft,
we have a programmer's tool which I will call
On the peer-to-peer mailing list for Program Q,
somebody asked the following question:
What's the best way to look at all tables created in the past week?
I want to repeat this command across multiple table repositories.
Somebody chimed in with the answer.
You are looking for something like
q find table -age lt 7d.
If you want to repeat across multiple table repositories,
you would say
q -server xxx find table -age lt 7d,
replacing xxx with the
table repository server name.
q find table -age lt 7d
q -server xxx find table -age lt 7d
This seemed to work, but there was a follow-up question:
What's the best way to get the repository server name for
any given repository?
For example, what are all the repository servers used by my test team?
Is there a central database I can query?
To get the repository servers used by your test team,
you um ask your test team?
The people on the Program Q peer-to-peer help
mailing list do not know the names of your test team's
There is no central database of all Program Q servers.
It's like asking,
"What's the best way to get the name of somebody's SharePoint site?"
Answer: You ask them,
"Hey, what's the name of your SharePoint site?"
SharePoint itself does not maintain a central database of all
but your test team might have a policy that all new SharePoint
sites should be registered in some central database.
You'll need to ask them.