ffscout

Thanks for the advice on this, I think you have something with the poorly written query, I've ended up moving the tempdb to a seperate drive at the moment so I did not have to extend the current one and can move it back once I comb through these queries.

I've checked the logs on the drive there and they are not that big having said that I never checked them until I restarted the service so I'll have to check that again next time it fills up. The Temp db is on the same drive, would it be a good idea to set it to auto shrink or will this have an impact on performance?

Hi, Not sure if I should put this in the SQL forum but I'll start it off here. I have been running SCCM 2012 for a few month now and on occasion the SQLServer service seems to eat up all the disk space on the D drive, I have both SCCm and SQL installed on that disk, this was fine I could just restart the service and everything would be ok for a good while. However in the last week it is constantly using up all the disk space to the point I'm having to restart the service multiple time a day. Any advice on why this is happening would be great and any tips to resolve the issue would be even better. Thanks

Hi, Thanks for this reply, I'm not very experiences with SQL, which parts of that do I need to change to change whit my own data? Just the Collection ID? Also is there a way a way to display a publisher column and only show the desired publishers? Thanks

Hi, I'm looking for a little help creating a query statement to create a collection to look for software from a specific publisher that has been installed within the last 30 days. I can get the collection to show all the machines with desired publishers software but I'm struggling to refine it to the last 30 days. Would a be better off using a report for this? If so then help with the query for that would be appreciated. Thanks