My bad, I think I understand what you're looking for now. Does the above query work? I edited it. I doesn't have the filegroup info but you can add that in if you'd like. You also have to make sure to use the correct database first, if you run this in master, it won't work.