Please PDQ, for the love of God.., when are we going to have the option to use an ENTERPRISE database?

Comments

12 comments

  • Robert Basil

    Two downvotes with no comments?

    Am I on reddit?

    Look, I LOVE PDQ Inventory and Deploy, if I didn't I wouldn't be spending all this time trying to make it work for us. I just want a usable solution for large enterprises. (20,000+ endpoints). There needs to be an option to use something more robust than SQLite.

    0
    Comment actions Permalink
  • Shane Corellian

    Hi Robert,

    You are correct in the fact that your environment is stressing out SQLite beyond its limits.

    The short answer is Yes. In all candor we are seriously examining Microsoft SQL. Before we ever implement such a big move several requirements must be met. I won't go into all of them here but first and foremost is the seamless (or as near to seamless as possible) upgrade of existing SQLite DBs.

    I will not provide expected dates on this move. The DB issue has our attention and not just in the passive sense.

    -Shane

    0
    Comment actions Permalink
  • Robert Basil

    Shane,

    That's exactly what I was looking for, thank you VERY much!

    Just an FYI, We would be more than happy to be an Alpha/Beta tester for MSSQL. I'm even willing to start with a fresh database, no conversion from SQLite needed.

    Thanks again.

    0
    Comment actions Permalink
  • Shane Corellian

    Thanks for the offer, Robert. When we get to that point we may reach out. These major changes always increase the ol' blood pressure so we are grateful for the offer.

    0
    Comment actions Permalink
  • Robert Basil

    You are welcome, sorry for the harsh posts on this subject, it's just been a very frustrating few months for me trying to get PDQ to work for us. I really, really, really would like to drop Manage Engine Desktop Central from our lineup.

    0
    Comment actions Permalink
  • Steve Cain

    I feel your pain. We use ManageEngine AssetExplorer, ServiceDesk, OpManager and EventlogAnalyzer and I hate all of them. They only thing they have going for them is that they are cheap, but the money you spend on staff keeping them running and upgraded offsets those savings. I'm looking for an affordable alternative to ELA right now and one of my co-workers wants to replace ServiceDesk/AssetExplorer. We're a much smaller shop than you but have MSSQL running on many servers so would not be averse to switching over to it instead of SQLite.

    0
    Comment actions Permalink
  • Marcel Lipovsky

    Just out of curiosity. Do the systems, PDQ Deploy is running on, contain any antivirus? If so, did you exclude the application data folders from scanning?

    Like

    C:\ProgramData\Admin Arsenal

    C:\Program Files\Admin Arsenal OR C:\Program Files (x86)\Admin Arsenal

    C:\Users*\AppData\Local\Admin Arsenal

    0
    Comment actions Permalink
  • Robert Basil

    No, I do not have any virus protection running on any of the machines running PDQ Deploy or PDQ Inventory.

    0
    Comment actions Permalink
  • Erik Curtis

    For what it is worth, I would support the move to MSSQL for the other possibilities it would offer. The ability to expose the DB to my developers for use in enterprise dashboards and management reporting would add a lot of value to the product. One of the best use cases for this would be in building a listing of approved software and then using SQL and the PDQ DB to compare against the applications found in our environment. The results would be submitted for evaluation/remediation to our ticketing system.

    I too would be interested in beta testing.

    0
    Comment actions Permalink
  • Webmaster

    Did you try the deployment from a system with a SSD drive?

    0
    Comment actions Permalink
  • Marcel Lipovsky

    Sorry for the SSD Question, I've forgotten to re-read your post and it seems that the Deletion of a post is not working as expected.

    I have just another question - What are your Performace settings in PDQ Deploy? Options > Preferences > Performance

    0
    Comment actions Permalink
  • Bret Levi

    wish i could up vote this again.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.