Jump to content

Steve G

Hornbill Developer
  • Content Count

  • Joined

  • Last visited

  • Days Won


Steve G last won the day on August 16

Steve G had the most liked content!

Community Reputation

87 Excellent

About Steve G

  • Rank
    Senior Member

Profile Information

  • Gender
  • Location
    Hull, UK

Contact Methods

  • Website URL

Recent Profile Visitors

1,759 profile views
  1. Hi @MikeW, My SCCM database looks very different to yours as I'm missing a number of those tables and columns, but I expect the issue you're experiencing is because you're using inner joins in your query, when you actually want to use left joins... So, as a very stripped-down example, the following is how you would return all assets. For each row, if a match from the left-joined user_disc table is found, then LastLogged will be populated with the value of employeeid from the matched record, and if a match is not found then the LastLogged value will be NULL: SELECT dbo.system_disc.netbios_name0 AS [MachineName], dbo.system_disc.user_name0 AS [LastUserName], dbo.user_disc.employeeid AS [LastLogged] FROM dbo.system_disc LEFT JOIN dbo.user_disc ON dbo.system_disc.user_name0 = dbo.user_disc.user_name0 I hope this helps Cheers, Steve
  2. What's Fixed: Hornbill/Docmanager/Link Document operation was failing due to a rights issue
  3. Hi @Steven Cotterell, Rather than providing an iBridge utility to perform this, I've written a new BPM node in Hornbill Collaboration to perform this instead (which is a much better method of providing a utility of this type). Timezone and Seed Time are both optional, and if not provided then it'll provide the current date/time of the session timezone. It will be available in the next update Hornbill ESP. Keep an eye on the announcements forum to see when this goes live Cheers, Steve
  4. @Lightsource I've just attempted to replicate this issue, and have been unable to I have a user in my test domain, who has a department of Research & Development, and have a Research & Development department group in Hornbill. When I import this user, the department is applied as expected. This also works for user updates as well as user creation. What version of the LDAP Import Tool are you running? Is there any information in the log regarding this user, that could give us a better idea as to what is happening? The information in the log is collated per user, so it should be pretty easy to spot any errors... For example, this is from my log for the user I've just successfuly imported: And the resulting user: Cheers, Steve
  5. @Lightsource Ah ok, I'll have a look at replicating this in the tool now, and will let you know how I get on. Thanks, Steve
  6. Hi @Lightsource, When you say you're using AD sync to add the department in to Hornbill customers, what mechanism are you using to get those in to Hornbill? Are you using one of our import tools to perform this, or an external script? At what point is this actually failing? Thanks, Steve
  7. Hi @Michael Sharp, You can just kill the LDAP import process on the machine that is running the import. Usually a Ctrl+C will work, or close down the command line, or kill it via Task Manager (on Windows). Re: checking your import configuration, it may be worth you importing just a single user (set via the LDAP query) and ensuring everything has imported as expected, before you do a full (or larger partial) import. Cheers, Steve
  8. Hi @TomW, Yes, it's certainly possible, that's actually how our Power BI integration and data export tool both work Basically, all you need to do is: Run the report using the reporting::reportRun API Once the report is finished, use the reporting::reportRunGetStatus API to get the report file names, and use this to build the report content file URL Perform a HTTP GET request on the file URL (remembering that you need the authorization header to contain an API key that has access to the report file, for authentication). Check out the code in those tools for working examples: https://github.com/hornbill/rPowerBIHornbillDataSources/blob/master/PowerBIDataSource_Report.R https://github.com/hornbill/goHornbillDataExport Cheers, Steve
  9. Hi @Dan Munns, Apologies for the late response, just catching up after being on holiday. I've tried the above, and if I have Where it happened: It happened here! anywhere in Custom C, and have Custom A updated with your matched ternary above, then Custom A is populated with the output of the match as expected? What's actually being written in to Custom A for you when you try this? Cheers, Steve
  10. @Steven Cotterell Thanks Yeah I've had a read of that thread. So is the issue that you're getting datetime values in UTC, and want to convert them to a specific timezone datetime before adding them to the new Teams post? We do have an API for that in the platform, so we could write an iBridge utility to do that if that's the case... Cheers, Steve
  11. Hi @Steven Cotterell, Apologies for the late response, I've been on holiday for a couple of weeks and am just catching up. Regarding the Credentials field being mandatory, this shouldn't be the case so I've raised this with the relevant team of developers to be fixed. Regarding the headers error - this is an issue with the way the field is being presented on the custom button form. The headers field is expecting an array, but the field will only ever give a flat string to the operation, so I've also raised this to be fixed. Cheers, Steve
  12. Hi @Martyn Houghton, Apologies for the late response, I've been on holiday for the last couple of weeks. I'll add this to the todo list, and will let you know once done. Cheers, Steve
  13. What's Changed Microsoft Teams iBridge integration - updated data source for Team searching to only return non-Security type groups, and allow typing to search for Teams.
  14. @Steven Cotterell Those utility operations should actually not be premium on your instance, they are free to use - I just had this switched on in my development instance from some previous testing... I've just updated the datasource which is used to return the Teams as part of the Post To Channel operation, so that it's now a search box rather than a drop-down select box, and it'll also now not return security groups (which it was doing previously). Give it 5 mins for the content pack to get to your instance, then try searching with the first few letters of the Team group display name... Note - this will only do a "starts with..." search on the display name, as the MS API we're using to return groups doesn't support "contains" as an operator. Let me know how you get on. Cheers, Steve
  15. @Steven Cotterell That's a good point actually, they probably shouldn't be premium. Let me find out why they have the flag and I'll get back to you shortly. The IFTTT one isn't marked as premium... Cheers, Steve
  • Create New...