{"id":3793,"date":"2021-01-08T10:28:19","date_gmt":"2021-01-08T09:28:19","guid":{"rendered":"https:\/\/bestdatasolutions.es\/microstrategy-change-journal\/"},"modified":"2022-06-15T09:49:14","modified_gmt":"2022-06-15T08:49:14","slug":"microstrategy-change-journal","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-change-journal\/","title":{"rendered":"MicroStrategy Change Journal"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3793\" class=\"elementor elementor-3793 elementor-2357\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-187471cb elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"187471cb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8a0c01d\" data-id=\"8a0c01d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1fbff00b elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"1fbff00b\" data-element_type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1920\" height=\"500\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Change-Journal.jpg\" class=\"attachment-full size-full wp-image-2417\" alt=\"MicroStrategy Change Journal\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Change-Journal.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Change-Journal-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Change-Journal-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Change-Journal-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Change-Journal-1536x400.jpg 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d1c2c13 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d1c2c13\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-5aae2e0d\" data-id=\"5aae2e0d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1a3ffa42 elementor-author-box--layout-image-left elementor-author-box--align-left elementor-author-box--image-valign-middle elementor-author-box--avatar-yes elementor-author-box--name-yes elementor-author-box--biography-yes elementor-widget elementor-widget-author-box\" data-id=\"1a3ffa42\" data-element_type=\"widget\" data-widget_type=\"author-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-author-box\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/es.linkedin.com\/in\/joacoatt\" target=\"_blank\" class=\"elementor-author-box__avatar\" rel=\"noopener\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/joaquin-attanasio-1.jpg\" alt=\"Picture of Joaquin Attanasio\" loading=\"lazy\" title=\"\">\n\t\t\t\t<\/a>\n\t\t\t\n\t\t\t<div class=\"elementor-author-box__text\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/es.linkedin.com\/in\/joacoatt\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<h4 class=\"elementor-author-box__name\">\n\t\t\t\t\t\t\tJoaquin Attanasio\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-author-box__bio\">\n\t\t\t\t\t\tBusiness Intelligence Consultant | Microstrategy Expert | Data Specialist\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41a959e0 elementor-widget elementor-widget-heading\" data-id=\"41a959e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-large\">Other Articles:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6c75b22c\" data-id=\"6c75b22c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5795bde9 elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"5795bde9\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-xl\">MicroStrategy Change Journal<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-561b31d1 elementor-widget elementor-widget-post-info\" data-id=\"561b31d1\" data-element_type=\"widget\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-869d2fb elementor-inline-item\" itemprop=\"datePublished\">\n\t\t\t\t\t\t<a href=\"https:\/\/bestdatasolutions.es\/en\/2021\/01\/08\/\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-calendar\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M12 192h424c6.6 0 12 5.4 12 12v260c0 26.5-21.5 48-48 48H48c-26.5 0-48-21.5-48-48V204c0-6.6 5.4-12 12-12zm436-44v-36c0-26.5-21.5-48-48-48h-48V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H160V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H48C21.5 64 0 85.5 0 112v36c0 6.6 5.4 12 12 12h424c6.6 0 12-5.4 12-12z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-date\">\n\t\t\t\t\t\t\t\t\t\t<time>08\/01\/2021<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7476169 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"7476169\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_linkedin\" role=\"button\" tabindex=\"0\" aria-label=\"Share on linkedin\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4 416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1 243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Share on facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-facebook\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15 37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11 71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Share on twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_whatsapp\" role=\"button\" tabindex=\"0\" aria-label=\"Share on whatsapp\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-whatsapp\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M380.9 97.1C339 55.1 283.2 32 223.9 32c-122.4 0-222 99.6-222 222 0 39.1 10.2 77.3 29.6 111L0 480l117.7-30.9c32.4 17.7 68.9 27 106.1 27h.1c122.3 0 224.1-99.6 224.1-222 0-59.3-25.2-115-67.1-157zm-157 341.6c-33.2 0-65.7-8.9-94-25.7l-6.7-4-69.8 18.3L72 359.2l-4.4-7c-18.5-29.4-28.2-63.3-28.2-98.2 0-101.7 82.8-184.5 184.6-184.5 49.3 0 95.6 19.2 130.4 54.1 34.8 34.9 56.2 81.2 56.1 130.5 0 101.8-84.9 184.6-186.6 184.6zm101.2-138.2c-5.5-2.8-32.8-16.2-37.9-18-5.1-1.9-8.8-2.8-12.5 2.8-3.7 5.6-14.3 18-17.6 21.8-3.2 3.7-6.5 4.2-12 1.4-32.6-16.3-54-29.1-75.5-66-5.7-9.8 5.7-9.1 16.3-30.3 1.8-3.7.9-6.9-.5-9.7-1.4-2.8-12.5-30.1-17.1-41.2-4.5-10.8-9.1-9.3-12.5-9.5-3.2-.2-6.9-.2-10.6-.2-3.7 0-9.7 1.4-14.8 6.9-5.1 5.6-19.4 19-19.4 46.3 0 27.3 19.9 53.7 22.6 57.4 2.8 3.7 39.1 59.7 94.8 83.8 35.2 15.2 49 16.5 66.6 13.9 10.7-1.6 32.8-13.4 37.4-26.4 4.6-13 4.6-24.1 3.2-26.4-1.3-2.5-5-3.9-10.5-6.6z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56263e9 elementor-widget elementor-widget-text-editor\" data-id=\"56263e9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>How are you, friends? Here I bring you a new episode of this beautiful segment called <i>#BestInMicro.<\/i>&nbsp;<\/p>\n<p>Today I am going to tell you about a situation I had recently. So, a manager asked me for a list of all the reports and objects that were modified by users. The ultimate goal was to detect which users had more privileges than they actually used because as we all know, depending on the licenses that each user has, the license price of MicroStrategy varies.<\/p>\n<p>My first thought was to do a simple search of all the objects and filter them by owner. In this way, I was going to be able to find that users are creating different objects. So far, so easy&#8230; until I ran into different situations:<\/p>\n<p>&#8211; First, it was not going to be able to detect who was modifying the objects.&nbsp;<\/p>\n<p>&#8211; Second, it is possible to change the owner of an object through properties. so the result of my search was not going to be entirely accurate.&nbsp;<\/p>\n<p>That&#8217;s when it occurred to me to look in the Change Journal, and for those who don&#8217;t know&#8230;<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0379d3e elementor-widget elementor-widget-heading\" data-id=\"0379d3e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">What is Change Journal?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6875d1d elementor-widget elementor-widget-text-editor\" data-id=\"6875d1d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This is a MicroStrategy tool that registers the modifications of the objects, and it can be consulted from the properties menu of each object:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f0bf3df elementor-widget elementor-widget-image\" data-id=\"f0bf3df\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"766\" height=\"306\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal.png\" class=\"attachment-full size-full wp-image-2367\" alt=\"Change Journal\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal.png 766w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-300x120.png 300w\" sizes=\"(max-width: 766px) 100vw, 766px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a78e20 elementor-widget elementor-widget-heading\" data-id=\"7a78e20\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">How to activate the Change Journal<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d83c42 elementor-widget elementor-widget-text-editor\" data-id=\"6d83c42\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In previous versions, it was possible to disable logging, but now this is no longer possible. However, in order for users to have access to view the activity log, it is necessary to grant the <i>&#8220;Audit Change Journal&#8221; <\/i>privilege. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54f9cec elementor-widget elementor-widget-image\" data-id=\"54f9cec\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"601\" height=\"456\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/audit-change-journal.png\" class=\"attachment-full size-full wp-image-2364\" alt=\"Audit Change Journal\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/audit-change-journal.png 601w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/audit-change-journal-300x228.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-546d3a1 elementor-widget elementor-widget-text-editor\" data-id=\"546d3a1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>By default, MicroStrategy even allows us to add comments when editing an object, which will then be reflected in the change journal. It is common to disable this input, but it is also possible to enable this input in <i>Tools &gt; MicroStrategy Developer Preference&gt;Optional Actions&gt;General&gt;Display change journal comments input dialog.<\/i><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-93b545e elementor-widget elementor-widget-image\" data-id=\"93b545e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"310\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-developer-preference.png\" class=\"attachment-full size-full wp-image-2391\" alt=\"Microstrategy Developer Preference\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-developer-preference.png 650w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-developer-preference-300x143.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef113d2 elementor-widget elementor-widget-image\" data-id=\"ef113d2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"248\" height=\"203\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/changes-comments.png\" class=\"attachment-full size-full wp-image-2385\" alt=\"Changes Comments\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d635a4 elementor-widget elementor-widget-heading\" data-id=\"1d635a4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Journal Record<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b9e47ad elementor-widget elementor-widget-text-editor\" data-id=\"b9e47ad\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Returning to our problem, although it is possible to see the modifications that the object had, my case was still very complicated because the project in question had more than 6000 reports (and logically I would not go through them one by one), but, in addition, I had only been asked for the web users. That is to say, I am not interested in obtaining information on the objects that were modified by the developer. <\/p>\n<p>For this, we must consult the complete journal record. Within the MicroStrategy <i>administration<\/i> menu, in the <i>System administrator<\/i> tab, we can find the change journal history. This tab allows us not only to filter the different fields on which we are interested in seeing the elements of the change Journal but also allows us to export it, so the only thing I needed to do was to define the project of interest, the access mode to be exclusive via web and the date range from which I was interested in extracting it. I had never used this filter before and I found it quite interesting.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b2640b elementor-widget elementor-widget-image\" data-id=\"4b2640b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"552\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-transactions.png\" class=\"attachment-full size-full wp-image-2382\" alt=\"Change Journal Transactions\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-transactions.png 834w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-transactions-300x199.png 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-transactions-768x508.png 768w\" sizes=\"(max-width: 834px) 100vw, 834px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-18830ce elementor-widget elementor-widget-text-editor\" data-id=\"18830ce\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>One last detail that caught my attention. The journal is not only divided by pages (i.e. the number of records), but also by transactions (save, delete, create, etc). <\/p>\n<p>Be careful with this, because they may think they have reached the end of the page when in fact it is the end of the transaction. The number of records displayed can be modified from the Intelligence server menu. To do this, the number of transactions and\/or records must be modified in the menu shown below:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f40cb42 elementor-widget elementor-widget-image\" data-id=\"f40cb42\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"608\" height=\"443\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-developer-browsing.png\" class=\"attachment-full size-full wp-image-2388\" alt=\"Microstrategy Developer Browsing\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-developer-browsing.png 608w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-developer-browsing-300x219.png 300w\" sizes=\"(max-width: 608px) 100vw, 608px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-699a209 elementor-widget elementor-widget-heading\" data-id=\"699a209\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Behind the scenes (how it works internally)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4bca67d elementor-widget elementor-widget-text-editor\" data-id=\"4bca67d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>And of course, as we are all curious and really want to get to the bottom of each of these things, we already know (from reading previous articles such as those <i><a href=\"https:\/\/bestdatasolutions.es\/blog\/microstrategy-metadata-queries\/\">on metadata queries)<\/a><\/i> that all MicroStrategy information is stored in Metadata and statistics tables.<\/p>\n<p>The change journal is no exception, and is stored in the following tables:<\/p>\n<p>DSSMDJRNOBJS: Basically the change journal. 4 columns: transaction, project, object, and modification made. While there is a code, <a href=\"https:\/\/www2.microstrategy.com\/producthelp\/Current\/SystemAdmin\/WebHelp\/Lang_1033\/Content\/Monitoring_system_activity__Change_journaling.htm\" target=\"_blank\" rel=\"noopener\"><u>KB44377<\/u><\/a> describes what each code refers to. Here is a query you can use.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e690e8e elementor-widget elementor-widget-image\" data-id=\"e690e8e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"784\" height=\"252\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-dssmdjrnobjs.png\" class=\"attachment-full size-full wp-image-2373\" alt=\"Change Journal DSSMDJRNOBJS\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-dssmdjrnobjs.png 784w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-dssmdjrnobjs-300x96.png 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-dssmdjrnobjs-768x247.png 768w\" sizes=\"(max-width: 784px) 100vw, 784px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bcbfa0d elementor-widget elementor-widget-text-editor\" data-id=\"bcbfa0d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><i>*Note: 1-3: Records any creation, modification, or deletion of any object.<\/i><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\"><i>4: Each time a folder is deleted, the changes are recorded in the parent folder.<\/i><\/span><\/p>\n<p><i>5-7: Link Items are objects that connect two or more objects (e.g., security filters connect users to metrics).<\/i><\/p>\n<p><i>8-10: Records each time the change journal is activated, deactivated, or deleted.<\/i><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ff9994d elementor-widget elementor-widget-text-editor\" data-id=\"ff9994d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><u>DSSMDJRNINFO:<\/u> Enter the details of the transaction, including what was done, when, from where and by whom. As before, here is the description of each type of transaction<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f37c1e3 elementor-widget elementor-widget-image\" data-id=\"f37c1e3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"327\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-dssmdjrninfo.png\" class=\"attachment-full size-full wp-image-2370\" alt=\"Change Journal DSSMDJRNINFO\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-dssmdjrninfo.png 786w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-dssmdjrninfo-300x125.png 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-dssmdjrninfo-768x320.png 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-274a40d elementor-widget elementor-widget-text-editor\" data-id=\"274a40d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><i>*Note: 1-3: The Change journal will be logged each time the user activates, deactivates, or wishes to delete the journal history.<\/i><\/p>\n<p><i>4-5: Records when saving one or more objects.<\/i><\/p>\n<p><i>6: Link items are objects that link two or more objects. For example, a security filter will link a user and a metric.<\/i><\/p>\n<p><i>7-9: Records when one or more objects or projects are deleted.<\/i><\/p>\n<p><i>10: Records when objects are copied.<\/i><\/p>\n<p><i>11: Duplicate users can be combined and this transaction is recorded.<\/i><\/p>\n<p><i>12: Record when using the &#8220;Unused Managed System Objects&#8221; in the administration menu.<\/i><\/p>\n<p><i>13: Create a new system property.<\/i><\/p>\n<p><i>14. Create a database password<\/i><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e0a414e elementor-widget elementor-widget-text-editor\" data-id=\"e0a414e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><u>DSSMDJRNLNKS:<\/u> This table reflects the &#8220;indirectly&#8221; affected objects. For example, if I modify an attribute, a filter affected by this change will be reflected here.<\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\"><u>DSSMDJRNOBJC<\/u>: This stores the comments made in the change journal.<\/span><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\"><u>DSSMDJRNOBJD<\/u>: Stores a little more detail about the modified object. This is crossed with the <i>DSSMDOBJINFO<\/i> and we will obtain all the details of the object. <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-837d03a elementor-widget elementor-widget-image\" data-id=\"837d03a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"973\" height=\"294\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-image.png\" class=\"attachment-full size-full wp-image-2376\" alt=\"Change Journal Image\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-image.png 973w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-image-300x91.png 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/change-journal-image-768x232.png 768w\" sizes=\"(max-width: 973px) 100vw, 973px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f1e1b1 elementor-widget elementor-widget-text-editor\" data-id=\"2f1e1b1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>I also leave here some comments that I found in &nbsp; <a href=\"https:\/\/resource.microstrategy.com\/LoginNew\/?ReturnURL=https:\/\/community.microstrategy.com\/s\/feed\/0D52R000087xzOxSAI&amp;redirect_url=&amp;app_secret=&amp;app_key=\" target=\"_blank\" rel=\"noopener\"><u>note from the community<\/u><\/a>&nbsp;that deserve a mention:<\/p>\n<p>&#8211; You can always use Freeform SQL in MicroStrategy to execute these queries. Therefore, you can review the change journal on the Web and even create distributions.<\/p>\n<p>&#8211; It is not recommended to create a new table within the metadata repository (why is explained in <a href=\"https:\/\/bestdatasolutions.es\/blog\/microstrategy-scanmd\/\">the ScanMD article<\/a>), but query performance can be greatly improved if we store our searches in physical tables.<\/p>\n<p>&#8211; Similar queries can be created using the Command Manager and the COM API; however, I personally found this to be much easier and more comprehensive.<\/p>\n<p>&#8211; Running multiple queries on the metadata repository database may affect the overall performance of the environment. Use them discretely.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-37f7921 elementor-widget elementor-widget-heading\" data-id=\"37f7921\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">References<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e3a128 elementor-widget elementor-widget-text-editor\" data-id=\"3e3a128\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/Best-Practices-for-maintaining-the-MicroStrategy-Metadata?language=en_US\" style=\"background-color: rgb(255, 255, 255); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\" target=\"_blank\" rel=\"noopener\">Best practices for maintaining the MicroStrategy Change journal Tables and Managed objects for optimal Metadata health<\/a><\/p>\n<p><a href=\"https:\/\/www2.microstrategy.com\/producthelp\/Current\/SystemAdmin\/WebHelp\/Lang_1033\/Content\/Monitoring_system_activity__Change_journaling.htm\" target=\"_blank\" rel=\"noopener\">Monitoring System Activity: Change Journaling<br \/><\/a><\/p>\n<p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/KB44377-Definition-of-Different-Transaction-and-Change-Types-in?language=en_US\" target=\"_blank\" rel=\"noopener\">Definition of Different Transaction and Change Types in MicroStrategy Change Journaling<\/a><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-614b2ec9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"614b2ec9\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f11abe elementor-align-center elementor-widget elementor-widget-button\" data-id=\"2f11abe\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/bestdatasolutions.es\/en\/blog\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">&lt;&lt; BACK TO BLOG<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>How are you, friends? Here I bring you a new episode of this beautiful segment called #BestInMicro. <\/p>\n<p>Today I am going to tell you about a situation I had recently. So, a manager is asking me for a list of all the reports and objects that were modified by users. The ultimate goal was to detect which users had more privileges than they actually used because as we all know, depending on the licenses that each user has, the license price of Microstrategy varies.<\/p>\n","protected":false},"author":2,"featured_media":2417,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[73,71],"class_list":["post-3793","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-articulo","tag-microstrategy"],"_links":{"self":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/3793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/comments?post=3793"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/3793\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/2417"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=3793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=3793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=3793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}