S02E30 - What's new in Intune Reporting w/ Spencer Shumway - (I.T)

hello and welcome to another episode of intune.training the stephen adams show the place to learn how to yourself into and i get it backwards even still a year and a half with the boys microsoft teams yeah hey it's steve and ben and jake and special guest spencer shumway from microsoft spencer can you tell us who you are and the things you do and uh then we'll jump into our topic sure hey i'm spencer shumway i'm a pm at microsoft been working on autopilot and most recently reporting i've been there two and a half years now and uh really liking it having a lot of fun and fun interacting with mvps and customers all around and a lot of people are interested in reporting so i wanted to come on the show and get out some reporting evangelism and let people know what's up excellent yes we're happy to have you here we're very thankful that you made some time to come and chat with us um just today i was i gave a presentation on feature updates and i got to show the new windows update preview reporting that is in tune now we did a video on that a couple weeks back i think when it first dropped um and so i got to show some of that coolness so we're very excited to dig into this i know that this is an an area that's kind of a black box for lots of folks and um hopefully we can shed some light on kind of what it is and how it works and why it is the way it is um so take it away all right we'll do um but yeah thanks for the call and i'm glad you enjoyed those feature update reports um they were a long time coming and we have more coming as well so um i alluded to that i guessed at that in our yeah there's the you got to click through to the to drill into the thing and it's it's like oh there must be more coming because they built this whole extra landing page for it give us rewards and luckily we also uh we just hired a new pm for for that specifically so oh very cool good we replaced dune he's dead to us no i'm just kidding he missed you but we we got someone else in to help out so fun bit of trivia dune was our very first microsoft guest we were at mms jazz in new orleans um he came on and chatted with us about um tenant attached all the cloud value stuff so i was at that conference by the way really uh-huh i gave an autopilot session oh yeah actually i was with john markham and okay i gave him my personal phone number at the time which was a huge mistake [Laughter] he's always on my back about reporting [Laughter] no he's awesome he's doing great stuff okay so let me share my screen i'm just gonna i'm just gonna kind of go over some high-level stuff about reporting but one interesting thing to note is like you said reporting is a black box for a lot of customers um we're always trying to get customer feedback we're always trying to improve the experience historically the experience hasn't been great i'll i'll be honest it's been a rough you know as intune's grown and you know went from startup to like a mid-tier and now now a fully fledged you know gartner leader in the uem quadrant we've made some investment areas and we've missed some investment areas and reporting has been one that historically was missed uh in a recent uh customer event that i was leading i had a survey out and i asked the customers how many of you view reporting in intune as either a blocker or how many of you view it as a blocker yes no maybe and over half were saying maybe or yes it's a blocker so a lot of customers view it as a as kind of a big issue and let me show you the work we're doing to make sure that we address that feedback and and get the experience where we need it to be okay so reporting in mem microsoft endpoint manager um the old way if many of you are familiar with the console is that you would see inconsistent experiences like you know maybe you'll have export but you won't have filtering you won't have column selections and the available columns are pretty limited typically you'll see experiences where sort search may work but other things are lacking like export so you've got a bunch of data there there's no way for you to get that data out of the console if you need to do something else with it which is pretty frustrating um and obviously you can kind of go in and muck around with the apis and probably pull it out that way but not user friendly at all and then last but not least we have the the dreaded load more on search which comes from basically ui side search parameters or filter parameters which are pretty terrible and kind of an example of this would be if you're maybe trying to troubleshoot an app installation historically and you would type your name in because you knew the app was installed on your device or failed on your device whatever the case may be it would come up with an empty page if your name wasn't on the first list but then there'd be the secret little load more button you're like oh what does that do turns out you have to click load more until you page through all the way to wherever your name happened to be which was terrible and if there's the sandlot uh would you want a s'more it's more of what i haven't had anything yet yeah yeah so for the big customers this was unusable it's completely broken because you know they've got 50 100 000 devices and some of these reports they're not going to click load more 100 000 times whatever yep uh so we just got a lot of feedback around all these things okay just inconsistent and just basic usability and we're like okay let's do something let's let's let's go ahead and invest here to make sure that our experience works and so that's kind of what what our new approach is microsoft endpoint manager reporting the new way is everything is server side search sort filter there's no more of the clicking load more and it's fast it works we migrated the devices list to our new infrastructure earlier last year i guess it's almost been a year now but you can go through search through you know upwards of a million devices within seconds and traditionally that's not been the case and in many of our reports today it's still not the case um but yeah really importantly just it works you can search you can you can do things that you would expect out of a reporting tool um and that's the thing i'll point out is that your picture right here i'm already sold on this concept because i see up and down arrows on every column and the names of every column are represented in that search box like we're like 90 of the way there yeah yeah that's what you're going to say because he's the donor oh yeah i know i'm a pie guy uh you're a pie guy we're actually trying to get rid of the donut there's just so you know but we'll see what happens anyways no no a line oh yeah can can we have it toggleable so we can change it from we need options but yeah so we're we're really trying to focus on hey let's make search usable let's make filter usable where possible let's make everything sortable everything searchable everything filterable now that's not always possible it doesn't always make sense there's some columns where it just doesn't make sense to to have a sort or there's some columns or it doesn't make sense to have a filter so that's not a hard and fast rule but that's kind of where we're going we're like leaning more towards empowering those experiences rather than just not having them at all and that kind of goes into the next thing the common ux controls so those sorting controls those filter controls the column selectors and the export that'll be common across the console so it's going to be the same experience and the same set of apis essentially driving all of this so you mean so you mean that that that because we're talking reporting but by that statement you mean every control on every page that has data in it will have all the same ux the same experience that's what we're shooting for and it's it's a long a long tale of kind of a you know a couple years worth of work but um that's what we're pushing for and we already have quite a bit of it there today as as you'll see um so yeah common ux controls and then last but not least better data export experience so this has been a really big issue for customers historically especially again our large customers where um if you have a huge data set it's taking you a long time to basically what you do is you go through the api and you kind of mimic the ui and you page through your data until you kind of accumulate all of it and do it that way for some of our large customers they're sitting there for 10 or 20 plus hours to get just one of their reports um which is pretty untenable yeah and it was to the point where you know the browser could crash um you know memory issues things like that so what you're saying is sorry what you're saying is there was a first level support guy that his job was to get in first thing in the morning and hit the load more button the whole day so that i'm the liberal guy yeah i mean the next quarter yeah yeah that's pretty bad and that was what we that's kind of what we historically told customers to do though like because we didn't have any way to kind of just give a true dump of all the data so um and that was the kind of the best practice that we offered and so i'm not not trying to knock it or anything it's just that it really wasn't super scalable and then again you had every team building separate apis so each api could potentially act differently perform differently and now with this this data export experience really really importantly is there's only one api that's it and so it all behaves the same it's served by the same infrastructure the performance is going to be the same and it's going to be a little bit more reliable and way faster so yeah let's get a little bit more in here so what about custom reporting this is a kind of a big one for customers because while we are trying to improve what we have in the console we're never going to get to the point where a customer or we're probably never going to get to a point where every customer is satisfied with every experience and so what that ends up being is customers coming to me and asking me for hey can you build this custom thing in the ui or you know wherever that request comes from partner teams or whoever and we can't always build custom things in the ui and you know we have hundreds of thousands of customers it just doesn't make sense so what we're trying to do is kind of expose the data so that you can take it out and do whatever you need to do with it and so in with that in mind we've given these kind of three main options here which is the graph export apis the azure monitor and mainly the log analytics workspaces is what we're seeing customers configure here uh and then the data warehouse so data warehouse has been here for quite a few years a lot of customers are using it a lot of our biggest customers are using it um a lot of people love it a lot of people are frustrated by the the amount of data that we kind of cover there and one key thing to call out in the data warehouse is that the data warehouse doesn't actually include all intune data and uh and so what kind of data is there you ask and and the general consensus of what we put there is a snapshot type data some historical data some trend data and we're usually not trying to take huge giant data sets and we can talk about that a little bit more in the future as well um but yeah that's that's just kind of generally like data warehouses for historical and and some aggregate and trend type data but again you won't get everything there so and you may get to this later on but what i because it's black box what is it to me i look at it it's just data why is it all in one place why like where where is the data in graph stored versus log analytics versus data warehouse and what makes it different or inaccessible from each of the others because i personally love log analytics and doing cousteau and being able to see the tables that are there easily without having to go dig through an api reference to go figure out the right entity to query for graph and that kind of so i'm looking at it from a sql perspective sql background like oh i data relationship log analytics makes sense to me yeah can you speak to like that structure and what's so unique about it yeah um so historically the graph apis like i've said have been built and maintained by each separate team so the apps team will have their own set of apis the device config team will have their own set of apis um autopilot enrollment team you know you name it they've got their own set of apis backed by their own data store the data store could be a couple of different technologies that are basically powering that data set and so even even if the apis are exposed via graph which is kind of a common layer the back end to those apis will often be different sets of technologies and they're maintained by different teams so each team may have varying levels of data engineering expertise and some may lack it and some may be great at it so historically it was pretty hit or miss as far as like performance and storage options behind the api so this is again not something that would be visible to you guys this is opaque to you but from our side we had disparate data stores and so data warehouse came along as kind of a solution that we would offer on top of not on top of the apis but aside from them which would give you a central storage solution and so we would kind of take all this data from all these different feature teams and pump it into one central place and then you have and we built a kind of a power bi connector that would be really easy to just plug in and use there and that model was it's pretty good it's very easy for customers to use it's very customer friendly but it's actually it turns out it's bad for us in the sense that um when we put all this data into the same database it can be pretty large amounts of data and pretty problematic performance wise again especially they end up being like a like a data swarm yeah yeah i mean i don't i don't know about that but it's uh the performance was actually pretty poor again for the larger customers and even mid-sized customers if you're pulling kind of the larger data sets um and it got to the point where we actually kind of like we were storing so much data there that we were tipping over our own sql instances that were running the data warehouse so that's again pulling back some of the data sets out of the data warehouse and we'll talk about one of those data sets specifically as well but data warehouse i think was kind of like our first attempt at like how do we bring this all together so we have some sort of common back end that you know has a common sla and those kinds of things um and then the next piece that i would say is it's tied into the azure monitor piece but it's it's really the new reporting infrastructure that i've been talking about um the new reporting infrastructure is actually based off kusto so we take all the op team data and the policy team data and all these different data stores and we we just pull it into one central place and that is now the central location that's serving the ui that's serving the exports and it's actually serving azure monitor as well so um before anything can become available for log analytics or azure monitor integration we first have to bring it into our new infrastructure so new infrastructure is kind of a centralized custo data store once the data is there we can make it available for azure monitor consumption and when i say azure monitor there's kind of three things inside of that there's uh storage blob storage event hub and log analytics and we've seen that a majority of our customers i think it's something like 98 or something when they're using azure monitor actually using like log analytics so that's definitely the most customer friendly and favorite uh cloud database and alerting and monitoring solution right now that we offer so just on that one spencer just curious um what sort of cost is there for customers to dump their data into the log analytic workspace it totally depends on the size of the customer that's like kind of the biggest thing um if you go on the log analytics pricing site you can see their pricing per gigabyte per month i actually kind of built like a little a little a really messy calculator just just so i could compare cseo's car or microsoft internal it costs and uh the calculation i found is that for about seven or eight hundred thousand devices which and so i ran this calculation for assuming maybe we can show the ui you guys want to pull up your ui and i can just show you yep uh i've got it i'll share it right now my mine still has the dots so let me know when you can see it yep yep yeah you want to do a quick zoom there one like one click okay perfect yeah yep so we're going to go to go to the portal.azure all right not po56 hey my keys my fingers weren't quite on the home keys i'm sorry and then go to monitor or lock just type log analytics all right [Laughter] last time we let you drive steve actually actually we do want let's go to azure monitor okay go to monitor yeah there we go should have diagnostic settings in here yep there we go yeah so um you should be able to find is that maybe click on that one yep so this is our one that we're using for um in tune but we don't have it turned on okay so if you like doing like add one really quick yep oh yeah you can't see it um basically we have kind of a set of tables that are available if you would i think that the intune one seems to be acting up right now but we have well it works from steve's intune side of things if you use so over an inch if i go to reports diagnostic settings oh all right they already stay yeah so you can see that the four tables we actually made available go back steve go to the edit right there those are the four tables so you can think of these as tables in our database that we've made available for our customers they can go select those tables and select either log analytics storage or event hub like so just out of interest if i was to put into storage account does that put it as a csv or is it table storage or what what is it presented out to the uh customers uh i think it's just json blobs actually yeah yeah that makes sense yep and then event hub um just for completeness of the conversation um event hub is around having it having the ability to do action straight away off that task correct yeah you can uh like you know listening to events it's kind of more for like a monitoring scenario but we don't again i haven't got a lot of customers using that and haven't done too much with it anyways so so that sounds like that's built for more for like a scom type yeah that's yes yeah or do action when device enrolls yeah as an example so right but you can do that in log analytics as well like they have alerting in log analytics so yeah but just just to be a little bit clear the devices table if you um if you configured that one i specifically calculated the cost for microsoft at microsoft we have about seven hundred thousand devices in our tenant and that's about forty dollars a month oh wow okay i'm impressed just steve double click on that guy and hit run so just to see the columns that are there still a little bit longer seven days back there you go there you go yeah so you've got 200 because we publish once a day so you have yep uh 200 divided by seven so you have about 30 devices maybe yeah there abouts yeah pretty close look at that good maths yeah so that would cost you like nothing like a dollar maybe nice so okay so but we're talking about cost and so back on the the set so if we choose not to check the box to bring that item into our log analytics workspace that continues to be something that is included in in our intune subscription that is of that you guys are you creating and using on the backend the data exists and is being stored on the back end for intune to use for all of the the back end apis to use but if we want to expose it for ad hoc reporting and things like like this like we've got on the screen that's when we would start incurring the extra cost then yeah you're pumping it into my workspace instead of the microsoft workspace yeah you can just think of it as where uh we're publishing data to a cloud database for you so a lot charging me for my own data come on man i mean a lot of customers have these big old beefy servers running you know sql server whatever it is that have cost thousands of dollars maintenance is extremely expensive the subject matter expertise required is extremely expensive the data pipeline reliability is probably less i mean i can't i can't say for certain on that but this is just a no hassle much easier way to kind of get a lot of that database and custom value for for pretty cheap but one key thing that i do always call out here is there's never like our goal is to never expose any data in log analytics that you can't already get for free from the console or from the export and so the api if you want to just pull it straight from the api and take it to power bi you can do that and that's free and and so this scenario is really more for for people who have kind of advanced needs who need to join data who need to uh you know potentially with aad data or other types of custom inventory data that they might be pulling with their own logs um i i think it's just a more advanced solution for folks yeah and as jake just pointed out in the chat sometimes some of us like to do cross supply i once wrote a query that had cross-supply like 15 times in it where's the shirt man [Music] so one of the other things that i like with log analytics and why we have this turned on and we've spoken about it previously is the fact that you can see all of the audit actions on your tenant so this is where if ben goes and does something on the tenant where he deletes an app or updates an app i can see that that actions occurred right so it gives you that overview as well just yeah to put that out there so yeah if you go back to the diagnostic settings can you just go back to that or i mean you can kind of see it here you've got intune audit logs in tune device components oregon tuned devices into operational logs um and then i believe audit logs and sign-in logs are actually from aad i'm not sure what operation is from um but yeah so basically we've only made a subset of data available here at this point but going forward we're actually trying to make it so that pretty much anything that's available via the export api would also be available for publication to log analytics and i think that's one of the things that's been holding a lot of customers back is we don't have kind of a critical mass of data there yet where they can find value in joins and and creating their own custom workbooks and and workbooks are pretty cool as well so but i don't think we need to get into that right now so let's uh let me flip back over to my powerpoint yeah the cost is like again like i said it's hard to predict um for device based ones it's pretty pretty easy if you if you know how many devices you have we can kind of break it down from there but like for audit logs and and some of the other log data it just totally depends on how many actions you have how many you know operational things are happening in your testing spencer before you go back to your powerpoint um because we like to make suggestions to the pms when we have them here um i i think a model you have to take it on but okay but fair enough you don't i'm just it's just just a thought so i know you've got the calculator um but even still it's like i don't know i don't know how much data is you know i don't know how many records i'm gonna get i don't even know what's in these tables before i go check the box how do i really know what i'm going to get wouldn't it be great if we had a trial period where you say turn you get 90 days you can turn on any of these things for 90 days and we'll spit out an estimate based on the usage you're bringing in or or even you can click the box and say please give me the estimate based on what you know i already know about my data from your back end you can calculate within the console using actual data that exists because you've already got it calculate it before you send it into my console using my data i think that would be powerful because there are numerous numerous things like cloud management gateway talk to rob york ask how many times he's had to explain to people how cheap a cloud management gateway is and yet there are people that are like we can't do that it costs money but we don't know how much money so how do we articulate to someone and i think that would be really awesome to be able to calculate it for me with my data yeah yeah especially with azure costing um the number of customers previously when i was uh as a consultant that would go and turn this on and then like two months later like oh we turned that off because it was costing us a whole heap of extra money that we weren't expecting and it's like prove to me that it was in tune it's like not we'll just turn it off yeah i that i i heard that so many times yeah no i i i totally get that i actually have a item on my backlog for that so i i have an item to build on a calculator but we'll see again we have to prioritize and who knows what'll happen that's i'd go first i'd go for sort and search on all the pages first i know yeah that's like we're really just we're really scratching the surface of like making the reporting actually work here uh there you go satisfy all the existing customers first and then all the way just have to wait right yes only adam asks [Laughter] the bottom of the list so let me uh flip back over here and this is why none of them will come back i know [Laughter] okay so we just had a good little dive on azure monitor log analytics um and and this expert api uh again it's a central api we've documented it uh we've explained which data is available via this api we should have probably a doc update coming out we haven't updated it for a few months so it's a little bit stale but we should have one coming up pretty soon where we give the kind of here's all the new reports that have onboarded so look out for that and and again like nothing is going to be in log analytics that you can't get for free out of the export api cool and i think just for the audience we've got and we'll put a link if someone remembers um we did a video on link accessing the data warehouse in power bi at some point um so i believe we've got one out already yeah i linked that that'd be awesome uh so yeah we talked about this again um there's kind of a paradigm shift here between how we've traditionally told people to do things which is the paging versus our new export api and the logic is different you're not going to just be able to point your scripts that you've been targeting your device config or your managed devices api straight at our exporting api and have it work luckily i have like an example script that i can share out and we've kind of given pretty decent examples in like a past ignite session that i gave and um and in the documentation we're actually pretty clear about how the api works and so it's not too complicated but it's different so um there's definitely customers who've complained about that but um as we progress and move along uh there's definitely some people are unhappy and grumble either way so the export api whenever a data set is available via the expert api we recommend that you use the export api and that you don't page on that data set so an example of this would be the all devices list if you're paging through the all devices list if you're kind of mimicking what the ui does the performance is actually going to be worse for you than it was historically um as we moved over to our new infrastructure um we're we're actually worse at paging than the old infrastructure was yeah but the whole reason for that is we tell people we don't want you paging don't hit us like the people are ddosing us yeah we have like 100 reports in the console so if even just one tenant is trying to grab all their reports and each report you know they're paging on it it's just a mess so yeah so full clarity uh i put a thing on twitter a couple of months ago saying hey i want to talk about paging and batch batching in in graph and almost immediately after i got a message from spencer going hey we should talk yeah yeah and it it's not a pro it's like it's nothing wrong right now but as again more of the data sets flip from the old infrastructure to the new infrastructure you will see either a your performance gets worse or b it will just not work at all exactly so that's why it's kind of important i think that we keep on top of what is available via export and you'll notice again that that these reports have moved over to our new infrastructure because search is going to work so it's going to work filter's going to run you know just the regular things will start to work and it's hard to keep up with i totally understand so that's why we kind of try and document and release updates when we can every month we release like you know in our what's new and in development which reports are coming out so um we'll try our best to keep up to date on the docs so you all know where we are at with that so yeah that's paging vs export we recommend again use export where possible um it's going to be great and and we drop off it's just a compressed csv file which you can load straight into power bi super simple right from the ui and a lot of customers are super happy again like i've had customers go from waiting 20 plus hours to a few minutes on their data exports so a lot of happy customers in that regard and spencer to be clear this is this is a function that i mean you had the the icon on the previous slide there the export with the the arrow so i've seen that in the console especially like just looking at the new autopilot i mean not the feature update reports um but what you're saying is you could if you're gonna like cons if i was gonna consume this in power bi and wanted to have this available all the time always fresh this would be something i would script out right i would i'd be able to script out the export yeah yeah you could do csv right yeah and that's one of the customer um feedback points that we've kind of taken and we're looking at how do we make it easier for that um because there's still some manual like if you know even if you download the script or if you download the file with a script how do you upload it to power bi and right now we say well look it's easy point and click but there is still the point-and-click and um so we're looking at other solutions of how we can kind of like fully automate the entire process and we'll talk about that later too but for now it is it is pretty easy and customers can kind of build automation as they see fit and and just so you know this export button technically could be serviced by our old apis or well not our apis our old infrastructure or our new infrastructure so it wouldn't really be clear to you unless you were inspecting the network traffic then you would see that some of them are paging and some of them are not yeah so all right so let's talk about a new uh a new announcement that i want to make sure everyone hears about we just released this in our what's new or not what's new in our in development docs for 2104 or no 2105 yeah 2105 which means this change is going to release it's actually not going to release because we're announcing three months early but essentially it's for the may release um yeah we're deprecating the application inventory data set in data warehouse and customers liked this data this data set for a few reasons but like you know the big one is it's just it's all of your devices and all the apps that we know about on those devices and so there's a lot of customers who have need for that for one reason or another um there are a few like limitations with the existing data set one of the big ones is we don't have win32 application data even we just don't have it and a lot of people aren't aware of that but it's a limitation so we're cutting this out for a few reasons but kind of the biggest one is it's actually too big for for our data warehouse right now it's super expensive and it's actually again it's one of those issues where customers who are trying to pull this data if they're you know decent-sized customers are taking hours and hours to get just this one table right um so it's super expensive it's not it's not performant and it's actually not completely accurate so for those reasons those are kind of the main big reasons and then you know the cost of maintaining this table is actually a little expensive as well from us from an engineering perspective we are deprecating this in 2107 so in july this is going to shut off and if you go look at the data warehouse docs you'll see that we have a note in there saying hey this is deprecating in 2107. um so anyone who's using this data set as like some sort of compliance tracking to you know track what apps are on every single one of your devices you're going to need to be aware of that luckily for you as part of the 2105 release we're releasing a new data set as part of the export api coming back to the export api where you'll actually be able to pull this in again super quick compressed csv format and one of the advantages here is that this is actually going to be a more accurate data set so we're we're improving the uh the accuracy and in the inventory and we're also improving the frequency of the inventory i think we're moving up to 24 hours so every day we're taking new inventory on the devices where historically it's been once every uh seven days i think um so increa increasing the the frequency uh and then we're actually adding win32 app data into this um the new export so look out for that in the what's new for 2105. um it'll be available in the ui and via the export api one other thing to call about that though is we will still be lacking certain types of win32 apps namely those installed from exes and we're targeting to fix that that gap i guess later in the year but it'll be more complete than this one so that makes sense yeah so just everyone know about that um so steve steve posted in the you know compressed well no it's fine it's fine this is just kind of making us making notes here so compressed csv is that a are you joking is that a ccsv format yeah i guess you got me on that one i don't have no clue is this real is that a real question because i'm probably going to have to work with this soon yeah i mean i can show you that later too yeah cool okay all right so yeah these are the data sets available um managed apps is basically here it's a little bit um it's actually not publicly available but it'll be there soon discovered apps the raw data that i just talked about which is replacing the app inventories is coming soon um some of the top-level compliance policies config policies um now just out of interest um spencer with the managed app ones and things like that uh what's the time frame we're looking at hopefully next month okay so in the next four legs yeah cool or it might be a 2104 actually okay yeah when you're on offer 2105. awesome yeah and that is the when you click on an app the the installation list per device and also the app installation report will be totally revamped which is pretty awesome so yeah mad export data is available we don't have ui reports for that though it's never been there we may look at adding it later devices list like i said threat protection feature updates like adam mentioned co-management eligibility and workloads and group policy migration readiness big data sets not there enrollment data is not there expedited updates are not there quality updates are not there again we just hired a new updates pm though so i'm hoping we can kind of target that for some time later this year autopilot data not there most resource reports so when you click on an individual policy or individual device we haven't yet moved the individual reports per paul per so they're they're called resources but we haven't moved the object level reporting over um and then most log analytics reports are not available so we haven't published the tables to log analytics and then resource access things like some of the cert data [Music] things like that are also lacking from the new infrastructure uh knew out new stuff we're thinking about uh i probably should have added like the uh log analytics calculator here as well but let's go for reports um json formatted export rather than csv some customers really want json uh as long as it's not xml we'll take whatever yeah yeah look at this i don't know if we'll actually do it the csv like the file transfer for csv is a lot better than json and from what the devs were telling me so interesting because dot json is four characters and dot csv is three well ccsv and then another cool one is we're looking at saving reporting views so trying to figure out how we can configure kind of a way to save your combination of column and filter selections a lot of people are going to be very happy about that i've yeah just this week i've had at least three people get annoyed that when they like leave a screen they have to go back in and put the uh the columns in yeah it's super annoying i don't know i can't say any timelines for any of these these are just kind of like top level things that a lot of customers ask me about i don't have any commitment here so no commitment these are just things we're looking at so spencer is this is this also is this azure wide an azure wide initiative um to like standardize on some of these things and the reason i'm asking is um if you go to the i think it's groups today it's one um it the default is like by the skuid or something instead of by the device names like it's alphabetical by the resource guide instead of and but but i think it's i think it's an azure entity that's in in like it's in the groups thing in intune or but it's an actual actually an azure object is how does i don't i don't know how the crossover works between in tune folks and the azure consumption pieces um well i'm actually i'm not sure about that piece that you're talking about but the report view saving is actually from azure we're taking that from them so they have a concept if you go to like your resources azure resources it's called managed views and you can save your your view which is your combination of columns and filters so we're trying to bring that into to men but it's a it's a lot of work so all right and then we have kind of a road map here again like we're just trying to get everything in the console on the new infrastructure to work um we want and then you know once we have all the reports there we want to make them available via the export api and azure monitor slash log um just so customers can get their data out and do that customer reporting again and then incremental improvements along the way there's a lot of stuff that we're kind of just as we go along we're like that's annoying or that isn't right um or we get a lot of customer feedback we're like let's go do this like let's fix this right now uh we're in the process of another one of those big items that we're trying to fix right now it's been six months it'll probably be like another six months but once it arrives i think a lot of customers will be really happy with it so just again a lot of improvements going on a lot of stuff behind the scenes that a lot of folks are not aware of but i think we're moving really well in the right direction and yeah with that i have a bunch of useful resources that i recommend any of you who are wanting to learn more about intune reporting go check out these have pretty much all the information you need to get started and even get pretty dang advanced for like some of this the api documentation the ignite session that i gave last year and uh this new github that i found recently which is pretty cool so you're going to want to pause your video right here so you can manually type all these addresses in so just yeah otherwise mark will put them down there will he just paste it in the video description or something yeah maybe we'll see and yeah that's about it that's it for the overview of intune reporting excellent guys do we have any any follow-up questions do you think we didn't ask as we went i'm super overwhelmed i'm just realizing how much work i'm gonna have in the next six months um but i think this is all moving uh you know uh forward in the in the correct direction which is exciting thanks for providing job security for all of us automation people exactly yeah you guys have plenty of work to do oh yeah definitely looking forward to it well i think this was this was wonderful spencer um and uh folks stick around spencer's actually gonna stay on and record another a more advanced session with us um so check out the next video coming with spencer if you've made it this far thanks and uh thanks thanks spencer and thanks guys see you next time see ya

Channel: Intune Training

Views: 3,729

Keywords: Microsoft, Intune, Training, Azure, AAD, MEM, MSIntune, Microsoft Endpoint Management, MEMIntune, Reporting, API

Id: lLNdS5ZlHoI

Length: 48min 43sec (2923 seconds)

Published: Mon Mar 29 2021

Reddit Comments

[u/GetFreeCash]

been waiting for this one! thanks as always Adam! :)