So, SP_spaceUsed worked for you?

I am working on the similar where I am using this(below) which works fine except (tempdb-->templog [log file])

So, I am also looking for alternate to eliminate...

I think the communication is under local network in your case, if the communication is in WAN then the scenario is different,

I am in the same situation but my networks...