OK absolute noob here. I've been "learning" SCCM 2007 for about a year and while I can do a lot of things, I cannot script so I am forced to dig out stuff from those of you online who generously share your knowledge.
I am diving into reports and queries but struggle with doing a copy paste of these reports and having them function without error. I am copy/pasting to word pad and then trying to paste it in to sccm but seems like it never works. My assumption is that I am not addressing or qualifying the tables that are being used. simply pasting the SQL statement: is not enough correct? I down loaded a utility - Creating Custom Reports By Using SQL Views but its a huge struggle if you don't know SQL.
My goal is to get one that shows me all devices that are member's of more than one collection and I would like, having now found it, to use this All-in-one report.
jm