It's probably more to do with your SQL config than with CM. Nevertheless,
I re-wrote it anyway.
This took 19 seconds to run for me, against a collection with 100k boxes in
it.
took 8 seconds against a collection with 100 boxes in it.
If the below still just runs/never finishes, you're going to
HI,
This report works on smaller collections, but when I bump it up to all systems
(with 5) systems it just runs for hours and hours and never ends. It runs
on collections with 7000 or so in them.
Is there something busted in it? I basically want a row for every pc in the
collection no
2 matches
Mail list logo
