doughall2015

Comments

  • MSSQL statement to get the top "users" for the past 90 days and their ticket totals. select d.FIRST_NAME +' '+ d.LAST_NAME as ClientName, count(a.JOB_TICKET_ID) from webhelpdesk.dbo.job_ticket a inner join webhelpdesk.dbo.client d on d.CLIENT_ID = a.CLIENT_ID inner join WebHelpDesk.dbo.status_type e on e.STATUS_TYPE_ID =…
  • The DB details should be in whd.db.host=stv-sql-021 c:\INSTALLDIRECTORY\conf\.whd.properties If you’re using PostgreSQL, then try this, running it from the server. www.sqlmaestro.com/.../ Mine looks like this, albeit MSSQL #Web Help Desk configuration file #Wed Jun 10 10:11:28 BST 2015 whd.db.port=1433 whd.db.sid=…
  • Being a VM, we reboot the server nightly.. Never had a problem since. <mydonate.bt.com/.../hazlewoods> <www.hazlewoods.co.uk> Hazlewoods is a member of international. A world-wide network of independent accounting firms and business advisors. Be accountable to the environment. Do you really need to print this email?…
  • "You cannot use this feature with an LDAP account"
  • I personally would like to be able to insert small Javascript snippets for both Analytics (Google or A. N. Other), and Chat Pop Up! <mydonate.bt.com/.../hazlewoods> <www.hazlewoods.co.uk> Hazlewoods is a member of international. A world-wide network of independent accounting firms and business advisors. Be accountable to…
  • It didn’t initially. But what we had to do was rerun the installation program, and do a REPAIR. Unsure why. This took seconds, and didn’t lose any data. If in doubt, email Tech Support. They will remote on, and do it for you. Do it first, and check the change in the System Information area it should change to “12.3.0 -…
  • Your API Key was visible Be careful.
  • I don't think it's a memory leak as such. I just think it's the nature of Java and how it deals with itself. Sent from the iPhone of Doug Hall I.T Dept For and on behalf of Hazlewoods LLP T: 44 (0) 1242 680000<tel:44%20(0)%201242%20680000> F: 44 (0) 1242 680857<tel:44%20(0)%201242%20680857> E:…
  • Got my vote. <mydonate.bt.com/.../stroudwomensrefuge> <www.hazlewoods.co.uk/.../pension-auto-enrolment-are-you-ready.aspx> Hazlewoods is a member of international. A world-wide network of independent accounting firms and business advisors. Be accountable to the environment. Do you really need to print this email?…
  • These signatures are client side, but they are all the same. Doug Hall I.T Dept For and on behalf of Hazlewoods LLP
  • Can you elaborate on the "Automate processes like "New employee" or "Employee termination process"" part; whether you are actually putting that feature into the next release. Also, do you have a time scale for the new version?
  • My version is still “12.3.0 - Build #12.3.0.462-416175” Should this have changed? Messages still can’t be deleted.. Doesn’t seem like much has changed. <mydonate.bt.com/.../stroudwomensrefuge> <www.hazlewoods.co.uk/.../pension-auto-enrolment-are-you-ready.aspx> Hazlewoods is a member of international. A world-wide network…
  • It begs the question WHY this is happening as I see this forum managed to convert my email nicely..
  • Tickets are effectively DELETED when you merge them. In the database, under the table “job_ticket” find the ticket number (“job_ticket_id”) and there should be a “deleted” column. Set it to “0” (Zero) Please only take this as advice, and you really shouldn’t mess with the DB directly.
  • MSSQL statement to get the top "users" for the past 90 days and their ticket totals. select d.FIRST_NAME +' '+ d.LAST_NAME as ClientName, count(a.JOB_TICKET_ID) from webhelpdesk.dbo.job_ticket a inner join webhelpdesk.dbo.client d on d.CLIENT_ID = a.CLIENT_ID inner join WebHelpDesk.dbo.status_type e on e.STATUS_TYPE_ID =…
  • This is actually a known issue with the WHD 12.3 RC (Beta Version) and can be fixed by installing the following: downloads.solarwinds.com/.../WHD12.3.0-Build-462-416175.zip Read the README inside the zip file. Let me know if it didn’t work.
  • Oooo. That would be nice!
  • Even if custom fields that were entered into the first task could be carried through/forwarded to all the tasks.
  • Weirdly, it’d probably be easier to migrate to MySQL, and THEN MSSQL <mydonate.bt.com/.../hazlewoods> <www.hazlewoods.co.uk> Hazlewoods is a member of international. A world-wide network of independent accounting firms and business advisors. Be accountable to the environment. Do you really need to print this email?…
  • Apologies all. 12.3