LeeWei 0 Posted February 12, 2019 Author ID:1298346 Share Posted February 12, 2019 @wpclau looks like a bug in the code. I determine the available properties (columns) from the first record. So if the first row does not have a "status.last_scanned_at" property, it will miss it. Normally the API returns a NULL value for the property, but in this case, the first row is not returning anything for "last_scanned_at". You can see the data returned by click on "Show API details" button. For a workaround, the list is returned sorted by ascending computer name. So if it is possible to ensure the first row has a value, that will make it work. Link to post Share on other sites
wpclau 0 Posted February 12, 2019 ID:1298347 Share Posted February 12, 2019 Ok, thanks for getting back to me and again, for the plugin. Link to post Share on other sites
amartilianom 0 Posted February 15, 2019 ID:1298819 Share Posted February 15, 2019 Hello, I'm trying to have the add-in incorporated in Excel but I don't get the menu to be shown despite the tool is correctly installed. I've tried installing it as a administrator and the result is the same, I've also checked if the ribbon is deactivated from the Excel options but it doesn't even appear there. Any idea what may be happening? My Office version is the one attached. Thanks in advance Link to post Share on other sites
LeeWei 0 Posted February 15, 2019 Author ID:1298838 Share Posted February 15, 2019 @amartilianom, the log files are located here: C:\Users\[user_name]\AppData\Local\Temp\Malwarebytes Excel Addin adregistrator.log is the log file generated during installation. adxloader.log is the log file generated when the Addin is being loaded in Excel You can send to me via private message, and we will look for errors. If think you have already done this, in Excel Menu --> File --> Options screen below, make sure that the Excel Addin is not in the Inactive or Disable lists. Lastly, I have message you with my contact info to help. Link to post Share on other sites
RickyF 0 Posted February 25, 2019 ID:1300530 Share Posted February 25, 2019 Hi @LeeWei, Everytime I try to generate a Detection and Therats report I get this message. No charts are generated after I press OK Thanks Ricky Link to post Share on other sites
RickyF 0 Posted February 25, 2019 ID:1300531 Share Posted February 25, 2019 OK. Sorry. I dindt see it Thanks @wpclau Ricky Link to post Share on other sites
LeeWei 0 Posted February 25, 2019 Author ID:1300552 Share Posted February 25, 2019 3 hours ago, RickyF said: Hi @LeeWei, Everytime I try to generate a Detection and Therats report I get this message. No charts are generated after I press OK Thanks Ricky @RickyF, there is a change in the API causing the error which I have fixed in version 2.3.1. Sorry about that. Lee Wei Link to post Share on other sites
RickyF 0 Posted February 25, 2019 ID:1300564 Share Posted February 25, 2019 understood. thanks Lee Link to post Share on other sites
RickyF 0 Posted April 2, 2019 ID:1306299 Share Posted April 2, 2019 Hi @LeeWei, I had noticed that my Malwarebytes menu was gone from the excell. I supposed that the last 365 upgrade wiped away. I have reinstalled the addin using the 2.40 last installer. Now I find this error every time I try to download data. What can be the problem? Thanks Ricky Link to post Share on other sites
LeeWei 0 Posted April 3, 2019 Author ID:1306415 Share Posted April 3, 2019 @RickyF I have seen this problem but having a hard time trying to duplicate the error. The error is local, and nothing to do with the Malwarebytes server. Basically, the code cannot create a new worksheet. Others have reported it, but then it goes away. I wonder if it has to do with another Excel process running away. Can you please use the Task Manager to double-check. Does the problem go away if you were to reboot the computer? Link to post Share on other sites
RickyF 0 Posted April 3, 2019 ID:1306418 Share Posted April 3, 2019 Hi @LeeWei, As usual you were right 🙂 I have restarted and everything works smooth Thanks again for your support Ricky Link to post Share on other sites
Kalrand 0 Posted August 7, 2019 ID:1328232 Share Posted August 7, 2019 Anyway of adding a check for updates on the Malwarebytes Cloud toolbar to stay up-to-date? Link to post Share on other sites
LeeWei 0 Posted August 8, 2019 Author ID:1328311 Share Posted August 8, 2019 @Kalrand you are referring to the Excel Addin itself is up to date? That makes so much sense, and maybe I should just pop a message (but not too often as to be annoying) once in a while? Link to post Share on other sites
Kalrand 0 Posted August 8, 2019 ID:1328374 Share Posted August 8, 2019 That or possibly something like this, https://docs.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2010/1zyc39fb(v=vs.100) or https://www.add-in-express.com/creating-addins-blog/2015/02/12/autoupdate-office-addin/. Not even sure if it's on the same page as how the Add-In was built, just something I ran across. Link to post Share on other sites
LeeWei 0 Posted August 8, 2019 Author ID:1328511 Share Posted August 8, 2019 @Kalrand Thanks for the information, very useful. Link to post Share on other sites
wep 0 Posted September 3, 2019 ID:1332743 Share Posted September 3, 2019 I am getting "Error extracting Endpoint data.: Exception from HRESULT: 0x800A03EC. Any ideas what is going on? Thanks for any help. Link to post Share on other sites
Kalrand 0 Posted September 3, 2019 ID:1332794 Share Posted September 3, 2019 3 hours ago, wep said: I am getting "Error extracting Endpoint data.: Exception from HRESULT: 0x800A03EC. Any ideas what is going on? Thanks for any help. Are you on the latest Add-in, 3.0.4? Link to post Share on other sites
LeeWei 0 Posted September 5, 2019 Author ID:1333138 Share Posted September 5, 2019 On 9/3/2019 at 8:29 AM, wep said: I am getting "Error extracting Endpoint data.: Exception from HRESULT: 0x800A03EC. Any ideas what is going on? Thanks for any help. I have seen this error when there are more rows than Excel can handle. This current Excel versions can handle 1M rows. - What version of Excel are you using - What operation are you doing when you get the error - Would you mind contacting me at lwei @ malwarebytes.com and I would like to find the bug. Link to post Share on other sites
wep 0 Posted September 12, 2019 ID:1334496 Share Posted September 12, 2019 Sorry I am just getting back. I am running the 3.0.4. Lee I am running Excel 2007 so this is the likely problem. I will email you so you can check it out. Link to post Share on other sites
LeeWei 0 Posted September 13, 2019 Author ID:1334599 Share Posted September 13, 2019 @wep Thanks for the extra context and information. Link to post Share on other sites
LeeWei 0 Posted September 13, 2019 Author ID:1334779 Share Posted September 13, 2019 @wep I have confirmed that Excel 2007 does not work correctly because there are APIs I use that is not available in 2007. Link to post Share on other sites
MnM33 0 Posted September 25, 2019 ID:1336951 Share Posted September 25, 2019 Hi @LeeWei! I'm currently in process of moving endpoints to different groups within the console, until I recently was pointed to this amazing tool! I see there is a way to move endpoints within the addin, however whenever I try to enter a computer name I receive a success message stating it successfully moved 0 endpoints to the group. I have tried multiple ways to enter the computer name into the box with no luck. Any idea why this would "fail"? Link to post Share on other sites
LeeWei 0 Posted September 25, 2019 Author ID:1337011 Share Posted September 25, 2019 @MnM33, We are meant to paste Machine IDs into the panel to move them to a different group, and not computer names. - First use menu Configuration and Options, and check the option "Import and Show ID Properties". - Next use menu Endpoint Computers to import a computers of interest. - You are meant to copy the ID column of the endpoints of interest to the Move Endpoints screen. Sorry that this is a little convoluted. Use either the Console or the Excel Addin for the job depending on which one is easier. The reason for the steps is that when I developed this for a customer, they have a complicated filtering criteria to select hundreds of computers before grabbing the IDs and pasting into the Move Endpoints screen. Please contact me if I can be of help at lwei @ malwarebytes.com. Link to post Share on other sites
MnM33 0 Posted September 27, 2019 ID:1337309 Share Posted September 27, 2019 This works though, for sure! I'm working on moving over endpoints over to our new EPR policies, and instead of doing them all at once I'm slowly moving them over into their new groups based off their locations. I'm moving to the larger groups now, so this tool will come in handy so I don't have to "manually" move them over one by one to their new homes. And with this tool that you have created I have bit more insight to see which groups, or rather which locations, are the most at risk. I'm glad this tool is here because now we can start getting a little more data to start a targeted training plan for our end users. Link to post Share on other sites
LeeWei 0 Posted September 27, 2019 Author ID:1337311 Share Posted September 27, 2019 4 minutes ago, MnM33 said: This works though, for sure! I'm working on moving over endpoints over to our new EPR policies, and instead of doing them all at once I'm slowly moving them over into their new groups based off their locations. I'm moving to the larger groups now, so this tool will come in handy so I don't have to "manually" move them over one by one to their new homes. And with this tool that you have created I have bit more insight to see which groups, or rather which locations, are the most at risk. I'm glad this tool is here because now we can start getting a little more data to start a targeted training plan for our end users. Please feel free to send me any enhancements and requests! Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now