Consolidating tables from multiple servers

  • I have a table on each of my servers that tracks permissions.  I use a PS script to populate it once a week.  What I need to do is to use a PS script to go through each of the 15 servers and write the contents of ...

    1. server1.mydb.permissiontable
    2. server2.mydb.permissiontable
    3. server3.mydb.permissiontable
    4. server15.mydb.permissiontable
    to a central report server RSServer.mydb.permissiontable.

    Can someone point me towards an example on how to do this?  Thank you

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply